Creating products in bulk with file validation

Modified on Wed, 5 Jun at 3:02 PM

Who can use this feature?

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

Available on Accounts with subscription to File Validate with Import and 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


How to upload products in bulk? 

1. Navigate to Import/Export > Import. 



3. Choose Source - Click on the File Validation with Import and select a file from your device and upload the sheet. 


Permissible file formats is xlsx 


When opting for the "File Validation with Import" as source, only the products meeting the configured criteria in PIMworks will be successfully imported into PIMworks. 
Products not meeting these criteria will be marked as rejected, allowing users to review and make necessary adjustments before reuploading the file.


When "File Validate with Mandatory and Import" module is enabled and user opting for the "File Validation with Import" as source, only products with all the mandatory data fields filled and meeting the configured criteria in PIMworks will be imported successfully. 
Products not meeting these criteria will be marked as rejected, giving users the opportunity to review and make necessary adjustments before reuploading the file.


4Upon uploading a file, the application will guide you to the 'Match Label' step.


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

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


   

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


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


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


10. 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 and subsequently mapped to their corresponding labels 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 labels, 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 in file 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.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article