Knowledgebase: CSV Export-Import

What Are The Default Product and Customer Export Sets?

 

Beginning with version 8.1, the product and customer CSV export functions will contain two pre-built export sets:

  • Default
    This will create an export file with only the more important column headers in order to make it a smaller file. This can be useful for situations where you have a large amount of data to export and - rather than having the CSV contain ALL the data - the default option will export only those columns which are most needed.
  • All Fields
    When selecting this radio button, the CSV file will generate with all of the available columns included. Keep in mind however that the generated file may be very large, depending on the size of your store's database.

Default Columns

Product CSV Export
For the Product CSV export file, the default export will contain these vital columns:

  • catalogid
    This is a unique database ID that will be used to keep track of each product in the backend of the system. This is not the same as the productid.
  • id
    It is the unique product id (SKU or Part Number) of the product.
  • name
    This is the name of the product.
  • image1
    This is the path to the main image used for the product.
  • thumbnail
    This is the path to the main thumbnail image used for the product
  • price
    The price of which you sell the product to the customer.
  • categories
    This is the name of the category the product is assigned to.
  • description
    This is the short description of the product. This is displayed in the Search page only by default.
  • keywords
    These are additional keywords used by the Internal Search of the site. This is also used in the dynamic Meta Tags for the product pages; the system will automatically generate Meta Tags using the NAME, EXTENDED DESCRIPTION and KEYWORDS of your product. These keywords do not show on the website to the customer.
  • stock
    This is the stock (Quantity On Hand) of the product.

Customer CSV Export
For the Customer CSV export file, the default export will contain these vital columns:

  • contactid
    This is the unique database ID of the customer record
  • billing_firstname
    This is the first name of the customer.
  • billing_lastname
    This is the last name of the customer.
  • billing_address
    This is the billing address of the customer.
  • billing_address2
    This is the second address of the customer (ex. Apt: 103 or Suite #103).
  • billing_city
    This is the billing city for the customer.
  • billing_state
    This is the billing state of the customer. Use the proper state 2 letter abbreviation (i.e. Florida should be FL).
  • billing_zip
    This is the billing zip of the customer.
  • billing_country
    This is the billing country of the customer. Use the proper country 2 letter abbreviation (i.e. United States should be US).
  • billing_company
    This is the billing company of the customer.
  • billing_phone
    This is the billing phone of the customer.
  • email
    This is the email of the customer.
  • shipping_firstname
    This is the first name of the customer.
  • shipping_lastname
    This is the last name of the customer.
  • shipping_address
    This is the shipping address of the customer.
  • shipping_address2
    This is the second shipping address of the customer (ex. Apt: 103 or Suite #103).
  • shipping_city
    This is the shipping city for the customer.
  • shipping_state
    This is the shipping state of the customer. Use the proper state 2 letter abbreviation (i.e. Florida should be FL).
  • shipping_zip
    This is the shipping zip of the customer.
  • shipping_country
    This is the shipping country of the customer. Use the proper country 2 letter abbreviation (i.e. United States should be US).
  • shipping_company
    This is the shipping company of the customer.
  • shipping_phone
    This is the shipping phone of the customer.
  • discount
    This is the customer group you would like the customer to be assigned to. You can create, edit and manage Customer Groups from the Shift4Shop Online Store Manager by going to Customers >Manage Groups.

Help Desk Software by Kayako fusion