Creating Products in bulk

Who can use this feature?

Super users and PIM Users with Read/Write permission for Import module

Available on Accounts with subscription to Import module

Super users and PIM user with access to the Import module can upload products using xlsx and csv file format

Prerequisite:

1. Attribute creation
2. Taxonomy node creation
3. Mapping Attributes to the taxonomy node

To Upload products in bulk 

1. Navigate to Import/Export > Import

2. Choose Source - Click on From File and select a file from your device and upload the sheet. 

Permissible file formats includes xlsx and csv only.

3. When uploading a file in csv format, the application will prompt you to choose the delimiter for the file.

4. Once delimiter is selected, it will take you to Match labels step

5. Upon uploading a file in xlsx format, the application will guide you to the 'Match labels' step.

6. Match labels – PIMWorks will automatically read the input file and map its headers to the predefined master attributes. You have the option to modify this mapping before proceeding with the file upload. 

It's essential to map SKU and Taxonomy nodes as these fields are mandatory.

If an attribute does not have an exact match in PIMworks, it will not be mapped automatically. You will have to either match your data to an existing attribute or create a new attribute for mapping the attribute and reupload the file

7. You can save the template using the save icon and reuse this mapping. 

You can now choose whether to update or skip attributes with blank values. If the "Update Blank Data" checkbox remains unchecked, the attribute value will stay unchanged.

8. After the successful upload of the file, you will be presented with a count of all the products that have been created, along with those that were not uploaded. 

9. Clicking on the 'View Status' button will lead you to a list page where you can exclusively observe the products imported from your file.

        
10. Within the PIM Input Import Summary, you can access a comprehensive list of all uploaded files, their corresponding statuses, and file reports. If there are any errors present in the input feed, these issues will be visible in the associated report.

11. You have the option to export the report, allowing you to review comprehensive information about the upload status of each individual product, including any accompanying errors.

Data Formats : 
1. When dealing with Taxonomy nodes, employ the ">" symbol as a delimiter to separate meta and sub taxonomy nodes.
2. For Categories, to distinguish between meta nodes and sub nodes, utilize "/" as the separator. Additionally, use "||" as a delimiter for adding multiple categories and should be mapped for the breadcrumb attribute. 
3. For both Channel and Storefront, ensure that they are specified in file and are subsequently mapped to their corresponding attributes during the mapping process.
4. For data of the "tags" type, representing keywords, and when dealing with "multiple" values in a multiselect dropdown, make use of "||" as the delimiter.
5. Date format should be MM/DD/YYYY
6. Date & Time format should be MM/DD/YYYY HH:MM:SS

Actions in bulk import

In Import, provide these values only in Action column

1. Insert - To create a product

2. Update - To update a product

3. Delete - To delete a product

1. In instances where the Action column is left blank, the system will interpret this as an intention to Insert.

2. By default, upon creating a new product in the Master, it will be automatically inserted into all available channels. Therefore, for updates specific to individual channels, the Action column should indicate "Update."
3. When a product is deleted, its variant products and any associated references from subscribed channels will also be removed.

Uploading Variants in bulk

1. To create a variant, mention the SKU of its Parent in Parent SKU attribute 

2. In Match label, Parent SKU in the import file should be mapped against the parent SKU from the pim attribute dropdown

Uploading Options in bulk

1. Create the products that you intend to link as related/option product, and designate these products as related to the main product. 

2. To indicate multiple options, employ the "||" delimiter, and add the option group names within square brackets [].

Related/Option products are created as a individual product and it will be mapped against any number of products.

The Group name added should be created in PIMworks as prerequisite  

3. In Match labels, Options attribute in the import file should be mapped against the Options from the PIM Attribute dropdown

The maximum file size permissible for bulk imports using both xlsx and csv uploads is 10MB.