How Do I Import Advanced Options Via CSV?

This guide will give you a step-by-step process to import your product's advanced options information.

Import Advanced Options

To import the advanced options of your products, we will first get a copy of the "Sample File" needed for the import. Log into your Shift4Shop Online Store Manager and, using the left 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 side of the page (Import), and click on the + icon next to the "Advanced Options" selection.

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

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

You may now add advanced option information to the proper columns. You will replace the sample information populated in the spreadsheet with your own information. Below is a brief description of each field. We will mark which of these is required and which are optional.

• Productid
  This is the unique Catalogid of the Product. This number was automatically generated by Shift4Shop when the product was initially entered into the system. To view a list of the Catalogids of your base products, you can perform a product export of your database. Keep in mind that this number is not the Productid/Sku. This is a required field.

• AO_Code
  This is a unique database ID that will be used to keep track of each advanced option in the backend of the system. To get this code, do an export of your advanced options and the column will be filled out with the AO_Code. This field is required also.

• AO_Suffix
  This is the part number of the advanced option. This is a required field.

• AO_Name
  The name of your advanced option. This field is required.

• AO_Cost
  The per unit cost (i.e. merchant's cost) of your advanced options. This field is optional.

• AO_Stock
  The stock number of your advanced option products. This field is optional.

• AO_Weight
  The weight of your advanced option products. This field is optional.

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

5. Go to Products > Product List.

6. Once there, look towards the top right of the page and click on the Export/Import button.

Look towards the right side of the page (Import), and click on the + icon next to the "Advanced Options" selection.

7. Browse for your file in the Import section.

8. Click Import Data.

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