Note that these are case-sensitive and values should not be capitalized unless you have made them that way such as a Category Name or Attribute value.
As this suggests, your product's SKU (Stock Keeping Unit) goes here! This must be a Unique value.
The Store View this is for. Mostly used for multi language, you can leave blank or default for the Main Store View
Deprecated. Do not use.
What type of product is this? Your options are: simple, configurable, virtual, downloadable, grouped or bundle.
The Category and Subcategories that this product will live in
To sort the Products within Categories.
Deprecated. Do not use.
The cost for the vendor. Does not apply to Bundle or Group products.
Deprecated. Do not use.
The long description with detailed information regarding the product.
Sourced from local farmers and made with all organic components...
Link to your already uploaded image. You will also find Small and Thumbnail to set these images apart from the base image.
The label that will appear when one hovers over the image
Information or short sentences that helps describe your product's page to search engines.
Wool sweaters just in time for the holidays!
Words that help describe your page to search engines.
Title to describe your page to search engines.
Your "As Low As" Price
Manufacturer's Suggested Retail Price
Your Product's name
Unisex Dinosaur Socks - TRex
New From and New To dates, to be used in your New Products Widgets
What the customer sees as the price
The shorter description that appears to the right of the Product Image on the Product page.
10% Recycled cardboard, please see additional information for more on our sources.
Sale Price for an item, not associated with a catalog sale
Beginning and end dates for the special price (Sale Price)
Is the product Enabled or Disabled? Enabled is 1, Disabled, 2
Tax code if you sell taxable goods (2) or charge for shipping (4). For non taxable goods use 0
The URL key that will show up after youstorename.com/
How will the customer be able to view this item? Catalog & Search, Not Visible Individually?
The weight of the item to be used with your shipping calculations.
How many of this product do you have in stock?
When the item's stock reaches this number, it will become out of stock.
Choose whether the product can be sold using decimals (e.g., you can buy 2.5 product)
Whether the SKU displayed on the Product Page should show the Variation SKU selected
0 = No
Minimum number of items in the shopping cart to be sold
Maximum number of items in the shopping cart to be sold
Defines whether the product is available for selling (0 - Out of Stock, 1 - In Stock)
The number of inventory items below which the customer will be notified via the RSS feed
Choose whether to view and specify the product quantity and availability and whether the product is in stock management( 0 - No, 1 - Yes)
Defines whether products can be automatically returned to stock when the refund for an order is created ( 0 - No, 1 - Yes)
The product quantity increment value
Defines whether the customer can add products only in increments to the shopping cart ( 0 - No, 1 - Yes)
Defines whether the stock items can be divided into multiple boxes for shipping.
Defines whether a Configurable Product or its individual Variations should skip shipping. To enable this feature go to Product->Settings->Inventory->Advanced Options and then change Enable Non-Shippable Products to "Yes". By default this will be "No".
The SKU of the products you want as Related
The SKU of the products you want as Cross Sell
The SKU of the products you want as Up Sell
The SKUs of the Simple Products that will be linked to this bundle Product
Default number for the bundle product's simple component
In a configurable product when a variation is selected what is the behavior with respect to the SKU displayed
The default variation to show when a configurable product is first loaded
Variation Product ID - Where Variation Product ID is the Entity ID which you can get by exporting your Products or looking at the Product ID in the Admin - see image below
Hide Add To Quote button for this product. Yes - hide, No - don't hide.
Enable Product Restriction for this product. Product will be hidden based on B2B > Product Restrictions for the below groups.
Multi-select customer groups to apply restriction to. Leave blank for all.
Customer Group NAME
Default quantity to be displayed in the quantity box on a product page
Numerical value, example: 1
Tier & Group pricing information.
Custom Option information.
_super_attribute_price_corr - Deprecated. Do not use.
Configurable Product Information.
You may have other attributes in here such as color, size, country_of_manufacture, manufacturer. All of these will be determined on the Attribute Set that you are using as well as the Attributes you have already set up.
Item ends with _position. Set a number to decide which choice will come first, second, third and so on.
User Default Settings
Any line that begins with useconfig you can enter as "Use config" to use your default settings.
Using HTML in your CSV files may cause issues with the import itself or the imported data. Please note the Support Team is not able to troubleshoot or assist with issues related to HTML in CSV files.
Row count in CSV Files
When working with CSV files please note that the header row doesn't count as "Row 1". The real row count would start with row 2.
Updated 3 months ago