In this article we will be discussing how to use CSV Files to Update your Inventory. CSV Files can be confusing for beginners but are very easy to work with once you know how. So, we will show you step-by-step how to keep your inventory up to date in this in-depth tutorial.
Reaching the CSV Import Screen
First, we need to reach the Listing Tool by clicking on the Listings tab of the main menu on the left-hand side of the screen.
Now, underneath the Listing Manager section, select CSV Import.
Updating your Inventory with CSV Files
To Update your Inventory, first select Update Listings, and choose Update Active Listings from the menu.
NOTE: For this method to work you must have your active listings linked to your Product Catalog and Inventory Control turned on. For more on Linking Listings, click here.
Next, we need to choose the location of our CSV File.
Once we have selected the CSV File we are working with our mapping section will unlock. First, we have to choose how we want EasyChannel to identify the items we are updating. You can either identify by SKU or Item ID.
We will be updating by SKU. Once you choose your method, you must then choose the column in your CSV File that matches your ID method. So, for us, our SKU column is under Handle on our CSV File, so we find Handle in the drop-down menu.
Now, we can focus on our goal for today, the Inventory section.
The first field we want to update is the Quantity Field. Quantity is the number of the item to be displayed as available on eBay. We want to find the matching field in our CSV File and select it from the menu. In our case it's Option1 Value.
Alternatively, if you do not have the matching option in the menu, you can use the Fallback field. For example, if your CSV Field used the heading Prod Quan for how many should be listed on eBay your screen would look like this.
The second column we are going to be adjusting is the WarehouseQuantity. This is your overall inventory of the item. Same principles apply to the columns here. Match your column with the corresponding heading from your CSV file. For us, it's Option2 Value.
Once we have these set, we can click Save Mapping Preset to save this preset for later to quickly update our inventory in the future.
When we are ready to import your file click Start Import.
You will see a Success message in your lower right-hand corner of your workspace, as well as a in progress notification in your Notification Center.
Your Notification Center will inform you when the update is complete. To get the most out of your changes, make sure Inventory Sync is turned on, and you are taking advantage of your Inventory Management Tools. To learn more about them, click here.
Suggested Reading: