Importing Products from CSV file

You are here:
< Back

You can import your products quickly and easily from a CSV file. Please refer to Importing products from Shopify if you have installed the Pickzen App in Shopify.

CSV file format

Before importing your products you need a valid CSV file with your products.

For example, say you have a catalog with three shoes, a valid CSV file might look like the following:

id,title,url,image,price,vendor,color,type,fastening
1,Ansi,https://mystore.com/ansi,https://mystore.com/ansi.jpg,25,vendor1,black,flat,thong
2,Filger,https://mystore.com/filger,https://mystore.com/filger.jpg,24.50,vendor2,blue,flat,thong
3,Esmeralda,https://mystore.com/esmeralda,https://mystore.com/esmeralda.jpg,125,vendor3,black,heel,slide

In this sample CSV, you can see 3 products with some standard attributes (id, title, url, image, price and vendor) and three custom attributes or tags (color, type and fastening). The fields are separated by comma. Instead of a comma you can also use another valid field separators such as: semicolon, vertical bar, or caret. If any of the fields includes the separator, you can use another non-conflicting separator or double quote each field. For example:

3,"Esmeralda S, L, XL",https://mystore.com/esmeralda,https://mystore.com/esmeralda.jpg,125,vendor3,black,heel,slide

Pickzen also supports multiple tags per field, but you have to use another valid separator for the cells. Say that the Filger shoe is in blue and white. Its CSV line would look like:

2,Filger,https://mystore.com/filger,https://mystore.com/filger.jpg,24.50,vendor2,blue;white,flat,thong

Importing products

Once you have the CSV, to start importing your products, click on the following button from Step 2. Add products:

Then, choose the import mode. In this case, File:

In the next step, we’ll define the separators according to the CSV file format:

In the next step, you have to match the Pickzen fields with your custom CSV fields:

As tags, we have to select all our custom tags: color, fastening and type.

Once done, you have to define which products to import. Please read the section below.

Two ways of defining the products to import

Once the file is processed, you can define which products to import selecting them one-by-one from the Products tab. To select your products simply click on the desired products.

You can also select all or deselect all clicking on the checkbox found in the header.

Instead of defining them one by one, you can import groups of them using tags from the Tags tab. This is only possible when your product feed is tagged. For example, to import all flat shoes:

You can add attributes to a blue box clicking on the box and selecting the attribute in the selector. For example, if you wanted to import all shoes that are flat and with slide along with all shoes that have heel and are tagged as comfort you’d define the tags as:

If you import your products from the Tags tab and you don’t select any attribute, all products will be imported:

Is there any difference between selecting all products from the Products tab and selecting All products from the Tags tab?
Yes, there is. Say you want to update your products from a new CSV file. In case you selected all your products from the Products tab, only the selected products will be imported but if you use the Tags tab new products can be added automatically, depending on the new product tags.

Editing products

When you edit a existing product from Step 2 Add products, a dialog window will show up where you can define its properties:

The fields are:

  • ID/SKU: The unique identifier of the product.
  • Name: The name of the product that will be displayed in the recommendations.
  • Vendor: Vendor of the product.
  • Price: Price of the product without the currency. The currency has to be defined in general settings.
  • Boost: The boost is used to sort the recommended products. If you want a product to be recommended before, give it a greater boost. The default boost for all products is 1.0.
  • Url: External URL of the product where the user can see more information when the recommended product is clicked.
  • Image: URL with the image of the product.
  • Description: Text with a description of the product. This description can be shown along with the recommendations.

Note the pin icon next to the Name and Description fields. Say you need to change the name or set the description to your products manually. If you import again your products to update them, the manual information introduced previously fore these fields will be overwritten unless you clink on the pin icon: