How do I upload my inventory through a .CSV file in bulk? (MW Enabled)

***Only applies to multi-warehousing users***

In ecomdash, you can upload your inventory by building a import format to match your file and uploading a .CSV file. 

Part 1: 

1. Navigate to Administration -> Import/Export formats

2. Click 'Add New Format' 

3. Give your import format a name and choose 'Add'

4. You will see two drop downs at the top of your format. One for Storefront and one for Warehouse. You will want to make sure you have the Warehouse selected from this drop down for the Warehouse you want to upload your quantity to. 

5. Choose 'add attribute'. Using the format type selection dropdown, choose product and listing to view different attributes, create a format that matches your .CSV exactly. Find the attribute you would like to add and choose the green 'plus' button to add to your format. 

6. Click 'save' to save your format. 

-Product attributes are attributes at the product level such as name, warehouse quantity, cost, Supplier, etc. 

-Listing attributes are attributes that are sales channel specific. If you change the storefront dropdown at the top of your import format, you can choose your storefront such as Amazon which will only show Amazon listing attributes in the listing attribute dropdown. 

-If your .CSV file contains SKU number, quantity, and name. You will find the attributes SKU number, Warehouse Quantity and Name to add to your format. 

-If your .CSV file contains 20 columns, you will want to have 20 columns on your format in ecomdash. If you cannot find an attribute within our system, use the 'Ignore' attribute to skip over that column. 

***Note: The required attributes for new products in ecomdash are SKU Number, Name, and Warehouse Quantity. *** 

 

Part 2: 

 

1. Once your format and file are complete, click the quick links with the Bulls-Eye Ecomdash icon located at the top left of your screen and choose 'Upload Inventory' from the Inventory section. 

2. Choose your file, format, and additional settings. 

-If SKU matches existing inventory you want ecomdash to: 

-perform no action: most commonly used when uploading new products within ecomdash. 

-Overwrite existing product details: most commonly used when adding more information to SKU numbers already in ecomdash. 

-Increase existing product quantity with file: most commonly used when adding more quantity to your products using the file. For example: if you have a quantity of 10 in ecomdash and you want to add 5 more using your file, you will choose to increase product quantity. This will then change the quantity in ecomdash to be 15. 

-Create new product if SKU does not match: If you have this checkbox checked, we will create a new product if we do not make a match on a SKU in ecomdash. If you do not want to add new products and just add more information to your products, we suggest making sure this checkbox is not checked. 

3. Click the blue 'Upload' button. 

4. To check the status of your upload, navigate to Support -> Upload Inventory history 

Was this article helpful?
0 out of 0 found this helpful