Shelf Quantities: Import/Export
Shelf Quantities represent inventory from sources outside the Ecommerce distributor network — your physical store stock, warehouse inventory, or Private Catalog products. Use this to manage quantities, lead times, and pricing for products you stock yourself.
Ecommerce Home Page > File Center
On the left-hand menu under Shelf Quantities, click "Client: Import Shelf Quantities"
Step 1 - Download Template
Download the Compatible File Template which is in the blue hyperlink. Open the File Template from your computer.
For this template and any others in Ecommerce, make sure that you review the developer notes so that you can ensure that your file meets Ecommerce specifications.
Step 2 - Populate Template With Data
This template has five (5) columns, some of which are optional. Below we offer an explanation of what each column header represents.
Template Columns:
| Column | Description | Required |
|---|---|---|
| Catalog.name | AFTERMARKET , OEM , or PRIVATE |
Yes |
| DistributorPart.distributor_sku | The distributor SKU in Ecommerce format with proper prefix | Yes |
| DealerInventory.quantity | Current quantity in stock. Whole numbers only — no spaces, no decimal points. | Yes |
| DealerInventory.lead_time | Days needed to ship. Use 1–2 for shelf stock or drop-shipped items; 3–5 for items requiring warehouse orders. |
Optional |
| DealerInventory.sale_price | The price for this product. Must be a valid decimal number without the $ symbol. Example: 43.99 |
Optional |
Step 3 - Upload Your Data
When you click "Client: Import Shelf Quantities" you will see "Choose File" next to File Upload. Click this button to locate the file on your computer. Double click your file and it will be ready to go in Ecommerce.
Enter your email address if you want to be notified when the job is complete. (optional).
Click Submit
Step 4 - Monitor Job Processing
You will want to monitor the Job that you just ran in File Center. The job will be in a Pending or Processing status until Ecommerce has completed it. These jobs typically take 30-60 minutes depending on the size of the CSV file.
Once finished you will see the job Completed or Complete w/ Warnings. Click on the job and you will have access to a Processing Report. Open the report and the success or failure of each line item will be reported.
Export Shelf Quantities
Location: File Center > Shelf Quantities > "Client: Export Shelf Quantities"
Exports all current shelf inventory data including quantities, lead times, and prices.
Alternatives to Manual Import
If you regularly update shelf quantities, consider these automated options:
- FTP File Automation: Configure Ecommerce to retrieve price/inventory files via FTP on a schedule.
- Lightspeed Integration: Connect Ecommerce to your Lightspeed POS for automatic price and inventory synchronization.