Help
Center
An imported CSV file with product information can contain the columns described below. You can import only the files that use the UTF-8 character set. If some values aren’t imported properly (or at all), please try saving your file with the UTF-8 encoding and importing it again.
This field is mandatory, and its value must be unique for each product. It can contain numbers, letters, or combinations (up to 32 symbols). If you plan to export product data to a CSV file, make sure that the CODE for each product is specified.
EXAMPLE: B0002OG6NY
If the value of the field is equal to any existing product code, the imported data will replace the data of that product.
A two-letter lowercase language code. This field is mandatory.
To find out a language code:You can see the language code in the Administration panel
EXAMPLE: EN
The numeric ID of the product from the store’s database. If Product code is empty, then Product id will be used to identify the product instead.
EXAMPLE: 13340
The full path to the main category of the product. Parent and child categories in the path must be separated from each other with the Category delimiter that you specify when you import a CSV file with product data.
EXAMPLE (the delimiter is ///): Computers///Desktops
Women///Clothing///Dresses
If the specified categories and subcategories don’t exist in the database, they will be created.
If the name of your category contains a colon (:), for example, Promotions///Discount: 10%, then you need to escape it like this in the imported file: |Promotions///Discount: 10%|. Otherwise, the category won’t be imported correctly.
:
|Promotions///Discount: 10%|
The price of the product in your store. It must be in 0.00 format.
EXAMPLE: 60.00
The recommended price of the product. It is used to display a discount label on the storefront: Discount = List price - Price. The list price must be in 0.00 format.
Discount = List price - Price
EXAMPLE: 75.00
The status of the product:
EXAMPLE: A
The amount of this product that you have in stock.
EXAMPLE: 50
The weight of the product. By default, weight is lbs.
EXAMPLE: 10.25
The weight must be an integral number or a decimal fraction with no more than two decimal places. The fractional part is separated by a full point (.).
.
The minimum amount of this product that can be purchased in one order.
EXAMPLE: 1
The maximum amount of this product that can be purchased in one order.
EXAMPLE: 10 (Set to zero for no limit)
The number of items of this product by which a customer can increase or decrease the number of this product in the cart. For example:
Then customers will be able to buy 2, 4, 6, 8, or 10 items of this product in one order.
The maximum number of choices in the drop-down list allows you to select the number of product items in the cart. For example:
Then customers will be able to choose between 2, 4, or 6 items of this product.
EXAMPLE: 10
Using List qty count will turn the Quantity input field on the product page into a select box.
The additional shipping cost for this particular product, which is specified in the primary currency of the store. The shipping freight is added to the shipping charges calculated at checkout; it can be used as packaging cost.
EXAMPLE: 2.00
Assuming that the calculated shipping charges are $50, and the shipping freight of a product is $5, then having 3 items in the cart would make the total shipping cost $65.
The date when the product was added. It uses the following format:dd mmm yyyy 00:00:00
EXAMPLE: 25 Dec 2019 14:05:00
If this field is not filled in, the date and time when the product was imported will be used instead.
EXAMPLE: Y
To allow the creation of downloadable products in your store, go to Settings → General and tick the Enable selling downloadable products checkbox.
The full path to the files of the downloadable product.
EXAMPLE: /home/client/public_html/purposemart-4.4.1/var/files/exim/backup/downloads/filename.pdf
The file can be specified without a path (just its name) if you specify Files directory when you import a CSV file with product data. Several files must be delimited with a comma.
EXAMPLE: file1.pdf, file2.jpg
EXAMPLE: D
This field determines what customers can do on the product page when the product is out of stock:
EXAMPLE: B
This field describes the action when the product price is zero:
The path (or paths) to product images. Multiple images can be specified by using the image delimiter in the additional settings on the File tab of an import preset.
EXAMPLE: exim/backup/images/main_image.jpg///exim/backup/images/additional_image.jpg
The image file can be specified without a path (just its name) if you specify Images directory when you import a CSV file with product data.
You can specify alternative text for images by adding it after the path.
EXAMPLE: exim/backup/images/main_image.jpg#{[ar]:Arabic alt text;[en]:English alt text;}///exim/backup/images/Nadditional_image.jpg#{[ar]:Arabic alt text;[en]:English alt text;}
If each product image has its own column (in a CSV file) or node (in an XML file), you can map all of them to Advanced Import: Images. Then these fields will be combined properly, and multiple images will be imported for a product.
The full path to the detailed product image.
EXAMPLE: /home/client/public_html/purposemart/var/files/exim/backup/images/detailed_image.jpg
The image file can be specified without a path (just its name) if you specify Image directory when you import a CSV file with product data.
You can specify alternative text for images by adding it after the path. For example, to specify ALT TEXT as an alternative text for image in English and German, import the image as follows:
EXAMPLE: /home/client/public_html/purposemart/var/files/exim/backup/images/detailed_image.jpg#{[de]:ALT TEXT;[en]:ALT TEXT;}
The full path to the product thumbnail image. Thumbnails are generated from detailed images automatically, so you need to use this field only if you want a thumbnail that is different from the detailed image of the product.
EXAMPLE: /home/client/public_html/Purposemart/var/files/exim/backup/images/thumbnail_image.jpg
Specifying the paths and alternative text of the thumbnail works the same way as for the detailed image.
The name of the product, which can contain up to 255 symbols.
EXAMPLE: Adidas Men’s ClimaCool Short Sleeve Mock
The full description of the product, which can contain up to 16 777 215 symbols.
EXAMPLE: ClimaCool is softer than cotton and resists pilling better than other natural and synthetic fibers. The shape and placement of ClimaCool fibers help move moisture quickly to the outer surface, where it evaporates away from the body.
An imported file may contain HTML markup that affects the look of the text. It often occurs in the description, for example:<p><i>ClimaCool</i> is softer than cotton and resists pilling better than other natural and synthetic fibers.</p>
For CSV files it doesn’t matter, but when you import an XML file, a problem occurs: XML and HTML tags both look like <...>, and Purposemart can’t distinguish what is what. That’s why HTML tags (a part of the description) must be separated from the XML tags (a part of the file structure). A text with HTML markup must be imported as follows:<![CDATA[<p><i>ClimaCool</i> is softer than cotton and resists pilling better than other natural and synthetic fibers.</p>]]>
<...>
The short description of the product, which can contain up to 16 777 215 symbols.
EXAMPLE: 100% circular rib Coolmax« Extreme 1×1 mini-rib solid pique mock with UV and anti-microbial finish.
The meta keywords of the product, which can contain up to 255 symbols; used for SEO purposes.
EXAMPLE: adidas, natural, climacool, mock turtleneck, golf shirts, uv protection, sun
The meta description of the product, which can contain up to 255 symbols; used for SEO purposes.
The list of search words for the product, which can contain up to 65 535 symbols. A product with search words can be found by entering these search words in the Purposemart’s built-in search bar.
EXAMPLE: adidas, climacool, men
Search is not case-sensitive.
The name of the page as displayed in a browser, which can contain up to 255 symbols.
A short promo text displayed on the product page
EXAMPLE: FREE US shipping over $100! Orders within next 2 days will be shipped on Monday
The names of the taxes which will be applied to the product. Several taxes must be delimited with a comma.
EXAMPLE: NYS, CA, VAT
All features that you import must follow this format:{Feature ID} (Group name) Feature name: Feature type[Feature value]
Several features must be delimited with a semicolon.
EXAMPLE: T[1233423423]; Release date: D[05/05/07]; Color: S[Red]
If a feature or its variant doesn’t exist in the database, it will be created automatically.
The common ID that ties multiple product variations into one group. For example, if you sell a T-shirt with features like Size and Color, then a medium white T-shirt and a small blue T-shirt will be product variations. If their variation group code is the same, customers will be able to switch between these variations on the product page.
A group code can contain only digits, Latin characters, and the following signs: - and _.
-
_
EXAMPLE: T-shirt_Need4Sports
This column will work only if the imported file also includes the Variation group code.
Multiple product variations can share one catalog item. In that case, customers will see only one of those variations in the product list on the storefront. Other variations will be selectable on the product page.
This column allows you to choose which variation customers will see first on the product list. It is not mandatory. Here is what happens if you don’t include this column:
We recommend using Variation so you can skip the options when you upload or add products.
All product options that you import must follow this format:(Storefront) Option name: Option type[Variant 1///variant_property=value///variant_property=value, …, Variant N///variant_property=value///variant_property=value]///setting=value///setting=value
Several options must be delimited with a semicolon (;).
;
EXAMPLE (text options): (Purposemart) Your age: IG; (Purposemart) Date of birth: IG; (Purposemart) Notes: TG
Variants can be specified for select box (SG) and radio group (RG) options right after the option type:(Storefront) Option name: Option type[Variant 1///variant_property=value///variant_property=value, …, Variant N///variant_property=value///variant_property=value]
EXAMPLE: (Purposemart) Size: SG[Normal,Large///modifier=10.000///modifier_type=P///weight_modifier=20.000///weight_modifier_type=A]; Color: SG[Grey///image=exim/backup/images/variant_image/grey_example.jpg,Black///modifier=50.000///modifier_type=A///image=exim/backup/images/variant_image/black_example.jpg]
Settings can be specified after the option variants. Here are the settings that you may specify:
The full path to additional categories to which the product is assigned. Parent and child categories must be separated with the Category delimiter that you specify when you import a CSV file with product data. If a product is assigned to several secondary categories, the paths to each category must be delimited with a semicolon (;).
EXAMPLE (the delimiter is ///): Computers///New products; Computers///Desktops
When you have multiple secondary categories, it can look like this: Best Products;|Promotions///Discount: 10%|.
Best Products;|Promotions///Discount: 10%|
The minimum and maximum number of product items to be shipped in a separate box. This field is used for automatic calculation of the shipping cost. The format of data in this field is as follows: min:[number];max:[number].
EXAMPLE: min:1;max:5
Dimensions of a box. This field is used for automatic calculation of the shipping cost. The format of data in this field is as follows:length:[number];width:[number];height:[number]
EXAMPLE: length:10;width:15;height:15
Numeric IDs of the user groups will be able to see the product. Here are the IDs that Purposemart have by default:
EXAMPLE: 0,1,2,3
The date when the product becomes available for sale. It is used when the out-of-stock action is set to Buy in advance. It must use the following format:dd mmm yyyy 00:00:00
EXAMPLE: 25 Dec 2020 14:05:00
The type of the product option exceptions:
EXAMPLE: F
The order in which option variants are selected by a customer on the product page:
EXAMPLE: S
The store that the item belongs to. This field is mandatory in Purposemart. However, you do not need to specify a storefront if you are uploading directly from the store’s admin panel.
EXAMPLE: Your Store
The SEO name of the product.
EXAMPLE: my-product
The popularity of the product. It is an integer that changes depending on the activity around the product (when the product is viewed, added to cart, removed from cart, or purchased). The higher it is, the more popular the product is.
EXAMPLE: 8
Powered by BetterDocs
