***Only applies to multi-warehouse users***
Ecomdash can grab your supplier’s inventory file from an FTP or HTTP location to import and process. The first step in getting this setup is to build the format within ecomdash so we know how to read in the file. To do this:
o Go to Administration, and the Inventory Import / Export formats.
o Click Add New Format and you can name it after your supplier to keep track of the feed.
o Once you click save you will be in the Import format detail screen.
o You will see 2 drop downs on the screen called Storefronts and Warehouse. You will want to make sure you select the specific Warehouse that you are updating the quantity for.
o You will then scroll down and click the green 'Add Attribute' button and a pop up will appear with a list of attributes for you to select. You will add attributes to your format to match your suppliers file.
For example, if the supplier file has SKU in column A of their CSV file, you will select SKU Number from the product dropdown and add it to the format in the first position. If Name is in the second column of the supplier file, you would select Name from the product dropdown and add it in the second row of the format.
You will want to repeat this to create an exact mapping of your supplier file and the ecomdash import format. If needed, you can use the 'Ignore' attribute in the product dropdown to provide you a placeholder for any column that is on the supplier file that you want to skip or not map into ecomdash.
Once you have an exact mapping of the file and the format, you will want to count and confirm the number of columns in the file match identically the number of attributes you assigned to your format.
***Note: The two required attributes to make sure your quantity is updated are SKU Number and Warehouse Quantity.***
Tip: If the products are new to ecomdash, you will need to make sure you have SKU number, Name and Warehouse Quantity.
Tip: The override value field for each attribute lets you define a “set” value for the attribute. When this value is set, ecomdash will populate the override value for all products uploaded instead of reading the value from the file being processed.
Now that you have built the format, take the supplier file and remove all but 1 row to create a test product file and save it to your desktop. Ensure you keep the file as a CSV file.
Within ecomdash, go to the Quick Links dropdown on the top left hand side of your screen, and take the upload inventory action. From there, select the file, select your new format you created and select your action to be overwrite existing product details. To confirm the status of your upload you can navigate to Support -> Upload Inventory History. You will want to confirm once the file has been processed that you see the product uploaded within inventory and that all of the data has been mapped accordingly.
If you see any fields not mapped correctly, you will want to revise your mappings in your format and run another test until you are happy that you have the fields where you want them.
If your supplier refreshes the feed and you have the FTP or HTTP information to connect to the location, here is how you can turn this import format into an inventory feed to grab the file automatically moving forward:
o Within your inventory import format (located within Administration, and then the binoculars of your Inventory Import format) you will see a checkbox to Enable Inventory File Integration. You will want to check that box.
o From there you will see a few additional fields to set. The first is how often you want ecomdash to go grab the file and process it within ecomdash. The quickest interval you can choose will be 4 hours.
o The next is the type of file that is on the supplier site such as a comma separated value (CSV) or tab separated Value (TXT).
o The last dropdown is to set the integration type which is to define if this will be an FTP or HTTP connection.
o If you select FTP you will need to define the URL of where the file is stored. The File Name is optional but if you do not define the name, ecomdash will process any CSV file located in the folder. You will also need to define the FTP Username and Password to access the file.
o If you select HTTP you will need to define the URL of where the file is stored. The URL location must end in .CSV. You will also need to provide the username and password for us to grab the file.
Once you click Save on the inventory import format, the format is now live as a feed and ecomdash will run based on the interval you defined to pick up and process the file.
Tip: When processing the file, if ecomdash matches on the SKU it will update the information accordingly; if ecomdash does not match on the SKU it will add a product for you to your inventory if you have the checkbox inside the binoculars of your format for 'create new product if SKU does not match' selected.
To check on the status of the feed, you can go to Support and then Upload inventory history and you will see a row for every time ecomdash has picked up and processed the file.
You can also check on the results of the process as it relates to inventory syncing by going to Support and then sync inventory history.