|
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.
|