XML import | PSQQQ - Products Importer

Build your feed, update prices & stocks

Build your feed, update prices & stocks

XML import


Import XML files into your store!
PSQQQ allows you to do full automation for products update and sync from any XML files for your stores.
You can add new suppliers XML files itself or to ask us to do that for you by request.

How to work with us

Fill the contact form or book a demo
We will estimate your task in 1-2 days.
It is really easy to import products info. if any issue create a ticket in the service and our Support team will help you!
Setup fields for data import 1 time and use it daily or hourly without additional setup time
Setup a scheduler and update your data automatically!

Find below how it looks inside our software for dropshipping.

 

Video instruction

Step 1 – Feed configuration for XML import


There are several options exist how to upload XML file
— from PC
— from URL, FTP, Dropbox, Google sheets etc.
— from Email
— sometimes it is necessary to download file from supplier website under client's login & password (it is possible but will require custom development)
 

Video instructions - creating a supplier's feed and uploading a file

 

Step 2 – XML format selection during XML import


— by default, the system does not know the format of file you defined,
— clever algorithm tries to detect format itself (in your case XML file) for
— if you see any issue with format detection, you can set the right variant manually

Step 3 — XML tags definition for XML file


— each XML file for import has tags

— user has to define what XML contains names, what column contains prices. It is columns matching
— there are 2 ways how to do that for XML file at PSQQQ
1) via tags definition

Step 4 — Define XPath for required fields of your XML file

A standard XML file consists of two blocks: a block with categories and a block with a product card. A block with a product card may include a sub-block with images, a block with characteristics, a block with product variants

 

Video instructions - Xml file structure

 
 

Step 4.1 — Loading categories during XML import

1) First, we define the root elements that contain categories and input them in the lines "Category._Item" and "Category._Root". The XPath to the root elements is inputed through "//"

2) Next, we input XPath for the attributes of the "category" tag: "id" and "parentId". XPath to the attributes is inputed via "//@"

3) Input XPath for the category name. To do this, we need to extract the values of the "Category" tag. The XPath for the category name will be "//text()"

4) Each product card has a tag that indicates which category this product has. Usually this tag is called "CategoryID". The XPath for "CategoryID" is inputed in the line "Product.CategoryId"

   

Video instructions - Input XPath for the category

 

Step 4.2 — Loading a product card during XML import

1) We define the root elements that contain the product card and input their XPath in the "Product._Root" and "Product._Item" lines. In some files there is no root element "Product._Root", in this case we input only "Product._Item"

 

Video instructions - Root element of product card

 

2) Then input the XPath to the values of the SKU (required input field), Name, Quantity, Price, etc.

 

Video instructions - The XPath to the values of the data

   

Step 4.3 — Uploading images during XML import

1) If the images are a separate block in the product card, then input the XPath to the root elements of the block with images and the tag that contains the link to the image

2) If the link to the image is registered as a separate tag in the product card, then input the XPath to the link in the line "Product.ImageUrl"

   

Video instructions - Uploading images

 

Step 4.4 — Loading features during XML import

1)If the features are located in a separate block in the product card, then input the XPath to the root elements of the block in the lines "Product.Features_Item" and "Product.Features_Root"

2) The XPath to the name and value of the feature is inputed in the lines "Product.Feature Name" and "Product.Feature Value"

3) If the features is located in the product card, then input the XPath to it in the line "Product.FeaturesExtra". First we input the name of the features, then "[--->]" and the XPath to the features. If there are several such features, then the separator between them will be - "[next]".

 

Step 4.5 — Loading products with variants during XML import

1)Loading product variants is similar to loading a product card, first we also define the root elements of the block with product variants and input the XPath to them in the lines "Variant._Root" and "Variant._Item""

 

Video instructions - The root elements of the block with product variants

 

2) Next, input the XPath to the product variant data that you need to download

 

Video instructions - The XPath to the product variant data

 

3) Loading product options with variants. If the options of products with variants are located in the file by separate tags, then input the XPath to it in the line "Variant.OptionsExtra". First, input the name of the option, then "[--->]" and the XPath to the option. If there are several such options, then the separator between them will be - "[next]"."

4) If the product options with variants are located in a separate block, then input the XPath to the root elements of the block in the lines "Variant.Options_Root" and "Variant.Options_Item". The XPath to the name and value of the option is inputed in the lines "Variant.Option Name" and "Variant.Option Value"

 

Video instructions - Loading product options