How do I import Product SKUs?

  • 0
  • 1
  • Question
  • Updated 5 years ago
  • Answered
Archived and Closed

This conversation is no longer open for comments or replies and is no longer visible to community members. The community moderator provided the following reason for archiving: Archived

This tutorial will cover how to Import your SKUs to manage inventory. To reach this area, first navigate to Products -> Import Product SKUs in your Control Panel. products-import_skus2013-05-19_1259.png

File Details
There are a few choices you can make when choosing a file to import your SKUs.

file_details2013-05-19_1301.png

1.) Import File Here you can choose which file you would like to import. You can choose between a file on your computer, or one that you have added via WebDAV to your server's import_files folder (typically for larger files). The file should be in CSV format, and, if uploaded from your computer, should not exceed 512MB.

2.) Contains Headers? In most cases you will want to leave this box checked. This lets the system see your column heads, i.e. the "Product SKU," "Product UPC/EAN," and "Stock Level" headers used in a standard Bigcommerce SKU Inventory Management template you may have exported previously.

3.) Field Separator This box is where you can enter the character that is used in your CSV file that separates each field or column. In most instances this will be a comma ( , ) so that is what is set here by default.

4.) Field Enclosure Which character is this field enclosed by within your CSV file? In most instances this will be quotation marks (i.e. "field one", "field two", etc.) so that is what is set here by default.

Link Import Fields
link_fields2013-05-19_1434.png
The Link Import Fields tab will provide an opportunity to match up your column headers accurately. For example, while Bigcommerce titles a column "Product SKU" by default, you or your vendor might use "Item SKU." In an instance like this, you would want to map the field appropriately, as both terms are referring to the same data. If you are using a SKU Inventory Management template you have previously exported and modified this mapping will not be necessary, as the headers are identical.

Completing Your Import
Once you have mapped your fields (if necessary), you can click Next>>.

next2013-05-19_1505.png

1.) Start Import You will be prompted to begin the import, at which point you can click Start Import

start_import2013-05-19_1434.png

2.) Import Completion The import should begin, and upon completion you will get a report of how many SKUs were successfully imported and, where applicable, how many failed to import..

success2013-05-19_1435.png


Photo of Drew N

Drew N, Community Manager

  • 259,164 Points 100k badge 2x thumb

Posted 5 years ago

  • 0
  • 1

There are no replies.

This conversation is no longer open for comments or replies.