Knowledgebase: CSV Export-Import

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 Shift4Shop online Store Manager and, using the left hand navigation menu:

  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:

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. Removing, adding, or editing any of the column names will prevent the import from completing.

  • id
    It is the unique product id (SKU or Part Number) of the product. This field is required
    (For advanced options, use the product variant's code set in Advanced options).
  • name
    This is the name of the product.
  • stock
    This is the stock (Quantity On Hand) of the product.
  • difference
    This column can be used to incrementally increase or decrease the product's current stock level.
    Use positive values to increase inventory by that amount, or use a negative value to decrease inventory.

As mentioned earlier, you need to have all columns present for the import to work so you cannot remove any of the existing columns. In the event you do not wish to use the name column, you may leave it blank. When running an import with a blank name column, it will not update your products' names. The same goes for the difference column.

Leaving the stock column blank, however, will update the product's stock to 0. So please keep that in mind if you attempt to do so.

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. Browse for your file in the Import section.
  2. Click Import Data

Please be aware that the import function has a limit of 30 megabytes. If the CSV you are trying to import is larger than this, please split it up into separate, smaller files no larger than 30MB each.

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

Additional Information
The actual import/export process takes place "behind the scenes" of your store's software to prevent it from interfering with your store's active processes. By allowing the function to work in the background, you can go to other pages of the admin and still work on your store while importing or exporting large files.

During the process, you will be taken to the Import/Export Status page which will display a grid layout of your recent imports and exports. The progress column will show you the progress of the import.

At the far right of each grid item will be an action wheel that contains the following options:

  • Download: Allows you to download the CSV file after a successful import/export
  • Notify Me: For larger, more time consuming files; this option will let you input your email address so that you will receive a notice once the import/export is complete.
  • View Log: Allows you to review the log of the import/export so you can see how many items were updated, inserted or if any records failed.
  • Cancel: Allows you to cancel an impending import/export
  • Retry: If for some reason the import/export fails, you may use this option to attempt a retry of the file.
  • Delete: Use this to delete the record altogether from the status page.

This will be present in all of the store's Export/Import functions.

Please make sure your store's secure URL is pointing to your Shift4Shop store.


Help Desk Software by Kayako fusion