What are the columns in the Inventory CSV import template?

Created: - Updated:

**If you want to import your Product data, please use the Product CSV import template.**

COLUMN NAMEFIELD NAME IN APPDESCRIPTIONACCEPTED VALUESEXAMPLE
sku SKU Required. A unique identifier for the product, assigned by you. The SKU must be unique for each product and cannot be changed once the product has any history (listings, orders, etc.). Any alphanumeric value no longer than 50 characters. Case-sensitive. Avoid spaces, quotes and other punctuation besides dashes (-) and periods (.) NIK-317086-001-14
quantity Quantity Required. The number of this product you actually have in stock, or the number (positive or negative) that you want to adjust the current quantity by. Whether you enter the actual quantity or a quantity adjustment, the type of adjustment must be consistent for every SKU in the file. A single CSV file cannot contain actual quantities and quantity adjustments. It must be one or the other. You will be able to choose the type of adjustment you want to make before uploading the file. Any whole number 452 or -4
cost Cost If receiving new inventory from a purchase order, the price you paid for one unit of this product. Used to calculate your average cost. Leave blank if not receiving new inventory. Any whole or decimal number 14.95
bin_location Bin Location Bin Location is the physical bin in your warehouse where this inventory is stored. Any alphanumeric value no longer than 50 characters. Avoid spaces, quotes and other punctuation besides dashes (-) and periods (.) A-1
Was this article helpful?
1 out of 1 found this helpful

Comments

  • Avatar
    Logan Wise

    May want to add an article discussing bulk cost/bin assignment. If a user wants to assign those values while leaving inventory quantities untouched, they could use "inventory adjustment" mode and fill the "quantity" column with zeroes.