Knowledgebase: Products
How do I import Product Inventory via CSV?

This article will give you a step-by-step process on how to import your product inventory information.

Import Product Inventory

To import your inventory, you will first need a copy of the appropriate sample.csv file. Log into your 3dcart online Store Manager and, using the left hand navigation menu:

Note
This article applies to importing product inventory data for regular products. If your products are using Advanced Options, then please refer to this article (click here) for information on the Advanced Options Import.

  1. Go to Products ->Product List
  2. Once there look towards the top right of the page and click on the "Export/Import" button

The Export/Import page will list a series of Export options on the left and Import functions on the right. Look towards the right hand side of the page (Import), and click on the +Icon next to the "Products Inventory" option.

  1. Click the link that says "Sample File" and download the sample file.

This action will download a CSV file named inventory.csv to your computer. Here's an example of what the spreadsheet will look like.

You may now add Inventory information to the proper columns. You will replace the sample information that has been populated in the spreadsheet with your own information.

Below is a brief description of each field:

Note
Do not remove, add, or edit any columns to this file.. If you do not have a need for a column please leave it blank. This is the exact format the file needs to be to import your Inventory information properly.

  • id
    It is the unique product id (SKU or Part Number) of the product. This field is required.
  • name
    This is the name of the product.
  • stock
    This is the stock (Quantity On Hand) of the product.

Once you have filled in your information, Save the edited CSV file on your computer.

  1. Go to Products ->Product List
  2. Once there look towards the top right of the page and click on the "Export/Import" button

Look towards the right hand side of the page (Import), and click on the +Icon next to the "Products Inventory" option.

  1. Click Import Data

The store will import you product inventory data and update the products accordingly.



Attachments 
 

Help Desk Software by Kayako fusion