Contents
- How to work with us
- Find below how it looks inside our software for shopgold dropshipping.
Import XML files into your shopgold store!
PSQQQ allows you to do full automation for products update and sync from any XML files for your shopgold 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
Find below how it looks inside our software for shopgold dropshipping.
Video instruction
Step 1 – Feed configuration for shopgold 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 shopgold 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 shopgold
— if you see any issue with format detection, you can set the right variant manually
— each XML file for shopgold 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 shopgold 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 shopgold 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 shopgold 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 shopgold 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 shopgold 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
