Miravia Open Platform
Arise - Create/Update products with OpenURL/FTP(Basic Template)
This document is intended as a guide on how to use the basic template management product.
Please refer to this document to complete the seller center setup before creating products in this document.
Note: This example uses the excel version of Basic Template to better display the fields. the fields in the CSV file and the excel version are the same.
Category List
Product Listing/Update
ProductListingUpdate_basic_template.csv
ProductListingUpdate_basic_template.xlsx
Update Price/Stock
UpdatePriceAndStock_csv_sellername .csv
UpdatePriceAndStock_sellername .xlsx
Download Template
1.Go to Seller Center and then to Automatic Feeds section
2.Select categories and download template
NOTE
- There is no limit to the number of categories.
- Only the leaf category can be selected.
Add products to the template
Note
- When creating a product, the first SKU is the base SKU, and this SKU must be inactive (not visible to buyers).Therefore, at least two SKUs are usually required when creating products using Open URL.If you want to create a single SKU product, then please do not fill in ParentSku, so that the created base SKU will be active.
- When creating more than one SKU for a product, the variant attribute is required. The variant attribute is a field used to distinguish each SKU, in this example the variant attribute is color family and size(The variant attributes of different categories may differ).
- The option of variant attributes of different SKUs in the same product cannot be duplicated.
- When adding multiple SKUs to a product, ParentSku must fill in the seller sku of the base SKU.
- Each row in the table represents a SKU.
- The URLs of the images in the Images1-8 column of each row cannot be repeated.
1.Fill in the mandatory fields
Note
- The category column is mandatory in Basic Template.
2.Fill in the fields of Optional as needed
3.Fill in variant attributes (single SKU products can be skipped)
The variant attribute is an identifier used to distinguish different SKUs under a product, so when creating multi-variant products, the variants of different SKUs of a product cannot be the same.
Field Description
| Field Name |
Field Description |
| Variation Name1 |
Level 1 sales(variant) attribute names, such as color family, size, etc. |
| Option for Variation1 |
Value of Level 1 sales(variable) attribute. |
| Image per Variation |
The image corresponding to the option of the first-level sales (variant) attribute. Only support to fill in the URL image, can not directly insert the image. |
| Variation Name2 |
Level 2 sales(variant) attribute names, such as color family, size, etc. |
| Option for Variation2 |
Value of Level 2 sales(variable) attribute. |
4.Fill in other parent product attributes(Attribute Name/value 1-10)
Note
- If you don't want to set this attribute or don't want to call the API, then you can skip this step.but the products will be updated with this attributes
- The Attribute Name and Attribute value fields are key-value pairs; Attribute Name identifies the name of the attribute to be set, and Attribute value identifies the value of the attribute.
- Please call the GetCategoryAttributes API to query the Attribute Name and Attribute value available for the current category, please refer to this document for details.
Sample file
ProductListingUpdate_basic_createproduct.xlsx
Manage products using templates
1.Update Products
There is no difference between updating products and creating products, when the SellerSku and ParentSku already exists, the system will determine that this line is updating rather than creating products.
Sample file
ProductListingUpdate_basic_updateproduct.xlsx
2.Add a new sku to an existing product
When adding a new sku to an existing product, please note that variant attributes cannot be duplicated and SellerSku cannot be duplicated. And ParentSku must be populated with the SellerSku of the exists Sku of the target product.
Sample file
ProductListingUpdate_basic_addnewsku.xlsx
3.Delete a product/sku
3.1 Delete sku
Each product can have more than one sku, this example is used to delete one of the sku in a product. If a product has only one sku then when the SKU is deleted, the product will also be deleted.
Note: When deleting some SKUs, the SellerSku in the same row cannot be the same as the ParentSku, and the ParentSku should be filled in with the SellerSku under the same product that has not been deleted.
Sample file
ProductListingUpdate_basic_deleteAsku.xlsx
3.2 Delete product
hen you need to delete an entire product, enter a SKU and make sure the SellerSku and ParentSku for that row are the same.
Note: This operation will delete the product and all SKUs under the product.
