Access this screen by selecting “Inventory” then “Import Products”
The Basic Import Stock File is used from the Import products screen. The Import is used as a common method to update in bulk hundreds of listings at once via an Excel Spreadsheet. The Basic Import Stock File covers simple updates such as price and quantity while more detailed control can be found on the Advanced Import Stock File. Please find more details on the Advanced Import Stock File here.
Downloading a Template or Your Existing Inventory:
Before you begin you can download either your existing inventory onto a Basic Import Stock File or a template to add new products to. To download the template go to “Inventory”, “Import Products”. Make sure the “Select Import Type” is set to “Basic” and hit “Download Import Template”
If you wish to download your existing inventory onto a Basic Stock Import File you can do this by selecting “Reports” on the menu. From the “Select Report” dropdown select “Stock Import File” then select “All Suppliers” and “Generate”. Once the file has been generated you will be able to click and download it from the “Results” table below.
NB. Import Stock Files require spreadsheet software such as Microsoft Excel
Working with your File:
Once you have downloaded your file and opened it your stock (or the template) will be laid open in front of you. Begin to fill it in with the data you are looking to use. Before you get stuck into your file I would strongly recommend reviewing the following helpfile with the most common reasons why Imports fail or are rejected.
Please find a list of the fields available within the report, what each does and if it’s required (Marked with a *) below,
- Sku* : The SellerExpress SKU number. Required if updated products.
- Barcode : Your products barcode
- CatNum : Your eBay SKU number / general catalogue number
- Title* : Your product title (Internal to SellerExpress only)
- Quantity* : Your stock quantity for this product
- Cost* : Your products cost / minimum price
- Default Sale Price : Your Products preferred / maximum price
- AUK Price : Your Products Amazon Price (If not using Repricing)
- Play Price : Your Products Play Price (If not using Repricing)
- Supplier : Your Products Supplier
- Format : Your Products Format
- Condition : Your Products Condition
- Location* : The Location of your product (Enter something, even if a full stop or 1)
Once you have completed your file make sure to save it as a .CSV (Comma Delimited).
NB. When adding new products make sure that the "SKU" field is left blank. SellerExpress automatically assigns a SKU to new products.
NB. New products must have a quantity. If a new product has a quantity of 0 it will not be added to SellerExpress.
Importing Your File Into SellerExpress:
Once your file has been created and saved you can import it back into SellerExpress by going to “Inventory”, “Import Products”. Browse for your file but before you hit the Import button you must select the correct Import Options for what you are looking to do. Find an explanation of each and what they do below,
- List on Amazon : Sets List on Amazon for new products.
- List on Play : Sets List on Play for new products.
- Update Products if Found : Updates existing products.
- Add New Format : Adds format to SellerExpress if it doesn't exist.
- Repriceable on Amazon : Sets Amazonrepriceable for new products.
- Zero Quantity for Items Not in File : Zeros quantities for items not in file for Supplier.
- Replace Quantity if Found (Appends if Unchecked) : Replaces or adds to product quantity for existing products.
NB. Products with over 40,000 listings will be split into multiple parts
NB. Zero Quantity for Items Not in File does not take effect on files with over 40,000 lines.
NB. Select “Allow Duplicates” if you have multiple of the same Barcode in your file. For example, the same product in multiple Conditions.
Zero Quantity Not In File & Single Supplier Imports:
If you use the Zero Quantity for Items Not in File option to import normally this is pretty cut and dry, if the product is not in the file then it will be set to 0 within SellerExpress. There is a single exception to this rule. If you only include a single supplier in your import then Zero Quantity for Items Not in File will only apply to products not included in that file with the same Supplier.
This option would allow you to, for example, have multiple dropshipping files and import them separately as long as you set the supplier to the name of your dropshipper for all products in their file.