感谢您的反馈!
This is the template to store all your sku infomation, Miravia will perform Create New Products/Update Products actions based on what users have provided by the Product Listing/Update Template.
Please remember to download the latest templates from Miravia's Seller Center-Products-Automatic Feeds before uploading the files.
We also provide the latest xlsx/csv templates here for your convenience.
ProductListingUpdate_basic_sellerfilename.xlsx
ProductListingUpdate_basic_sellerfilename.csv
Please pay attention to ParentSku and SellerSku column in the template, Creating or Updating products are mainly determined by different combinations of ParentSku and SellerSku.
Here are the cases:
2.1: Case1-Creat a new product
2.2: Case2-Add a new sku to the existing product
2.3: Case3-Update the product
Here is an example:
When creating products: The same SPU with multiple SKUs should have a same ParentSku(TestProduct01) and the SellerSkus(TestProduct01-a/TestProduct01-b/TestProduct01-c/TestProduct01-d) should be put as concecutive rows together. New SPU+SKU will be created as long as they are not existed ones in your store.
Here is an example:
When adding a new Sku into an existing SPU: The new adding SellerSku(TestProduct01-e) should not exist in your store. ParentSku(TestProduct01) is mandatory and the existing one.
Here is an example:
When updating products: No need to input parentSKU value, only filling SellerSkus(TestProduct01-a) can update the existing SPU and SKU information.
Please, be aware of the Short descriptions for each of the fields. A wrong filling of the file may cause failure of listing or updating.
Note:
1) Before filling the file you need to map the categories in order to set the right key attributes and it possible values.The category must be a leaf category.
2) There are some categories that need to be approved by Miravia before you can use them,please check with your category manager.
3) You can get all the attributes by /category/attributes/get API to find the available or required attributes of the target categoryID. Please refer to this tutorial Miravia - Get category attributes on Open Platform-Getting Started.
Field |
Explanation of this field |
Mandatory |
Short description for frequent rules |
Category |
Indicate the appropriate category ID for each product. |
Yes |
-An accurate category ID would boost search results. Please input the correct leaf category id. You can download a category list in Miravia's Seller Center. -There are some categories that need to be approved by Miravia before you can use them.Please check with your category manager. -The category must be a leaf category. |
Category name |
Indicate the description of the category id, This is key for products to be categorized and easy for buyer search and browse by different product category. |
No |
-Please input the correct leaf category name.It must matches with the category id. -There are some categories that need to be approved by Miravia before you can use them.Please check with your category manager. |
Product name |
Product name is key to show what product it is. Brand name and Model/collection/distinctive selling points are highly recommended. |
Yes |
- Sensite words not allowed. Avoid irrelevant keywords as it may cause the listing to be banned. -Up to 48 characters are recommended to show key selling points. especially it's the best to display in search results list. (Max 255). |
Product images 1 |
The URL of the 1st generic image of the product. The most important main image to inspire buyer click or actions.White background required and aspect ratio 1:1 are strongly required for better display. |
Yes |
- Image can't be missing for product. Size between 330 and 5000px and white background required. Max 8 images and file size < 5M. Support url with sufix: JPG/PNG/WEBP. |
product images 2 |
Other image to display different side of the product. eg: left side/right side/back/details to zoom in. etc.Duplicated images will be reported with an error. |
No |
-Image size between 330 and 5000px and white background required. Max 8 images and file size < 5M. Support url with sufix: JPG/PNG/WEBP. |
product images 3 |
Other image to display different side of the product. eg: left side/right side/back/details to zoom in. etc.Duplicated images will be reported with an error. |
No |
The same as above product images 2 |
product images 4 |
Other image to display different side of the product. eg: left side/right side/back/details to zoom in. etc.Duplicated images will be reported with an error. |
No |
The same as above product images 2 |
product images 5 |
Other image to display different side of the product. eg: left side/right side/back/details to zoom in. etc.Duplicated images will be reported with an error. |
No |
The same as above product images 2 |
product images 6 |
Other image to display different side of the product. eg: left side/right side/back/details to zoom in. etc.Duplicated images will be reported with an error. |
No |
The same as above product images 2 |
product images 7 |
Other image to display different side of the product. eg: left side/right side/back/details to zoom in. etc.Duplicated images will be reported with an error. |
No |
The same as above product images 2 |
product images 8 |
Other image to display different side of the product. eg: left side/right side/back/details to zoom in. etc.Duplicated images will be reported with an error. |
No |
The same as above product images 2 |
Brand |
Indicate your product's brand. |
Yes |
- Choose from the SellerCenter or input directly. |
Long Description |
Indicate details of your product. A good product description enhances the quality of your listing and increases chances of sales. |
No |
- Please input 20 to 3000 characters for product description. -Sensite words not allowed. -Leave it blank when updating product will be considered as no change. |
Hazmat |
Indicates if the product has hazardous material. |
No |
-Inaccurate filling may result in additional shipping fee or failed delivery. |
Variation Name 1 |
Indicate specific variation of your product. This is to define what options for buyer to select when placing orders. Eg: Colors.size.etc. |
Conditional Mandatory |
-You can create your own Variation but we strongly recommend you to use existing values for better search results. -Variant value of the same SPU can't be duplicated. -SKU counts are only allowed 150 lines under 1 product.Too many SKUs are not easy for customer to select. |
Option for variation 1 |
Value of the varition.This is to define what SKUs for buyer to select when placing orders. eg: Green + XXL skirts. Red + XL skirts. |
Conditional Mandatory |
-You can create your own Variation but we strongly recommend you to use existing values for better search results. -Variant value of the same SPU can't be duplicated. -SKU counts are only allowed 150 lines under 1 product.Too many SKUs are not easy for customer to select. |
Image per variation |
This is the image of first variation name so that buyer can select with a preview from a small image. eg: image for Color.And it would be better not to put image for size. |
No |
*-Whitebackground and aspect ratio=1:1 are required. -The images of the same SKU cannot be duplicated. -Please remember to set images of all vatiations or leave all of them empty. -Please make sure the variation of the category is allowed to set images. -Only Variation1 can set images. If you customize variants: which variant you set images for.this variant will be Variant1. For example.the product set two variant names: color family and size. if you customize size and set images for it. then size is Variant1. so images are added to size instead of the default color family. |
Variation Name 2 |
Indicate specific variation of your product. This is to define what options for buyer to select when placing orders. Eg: Colors.size.etc. |
Conditional Mandatory |
-You can create your own Variation but we strongly recommend you to use existing values for better search results. -Variant value of the same SPU can't be duplicated. -SKU counts are only allowed 150 lines under 1 product.Too many SKUs are not easy for customer to select. |
Option for variation 2 |
Value of the varition.This is to define what SKUs for buyer to select when placing orders. eg: Green + XXL skirts. Red + XL skirts. |
Conditional Mandatory |
-You can create your own Variation but we strongly recommend you to use existing values for better search results. -Variant value of the same SPU can't be duplicated. -SKU counts are only allowed 150 lines under 1 product.Too many SKUs are not easy for customer to select. |
Ean Code |
Indicate the European Article Code of your product. |
Conditional Mandatory |
-Be aware that this value is uniqe and can't be duplicated in your store.Which means each EAN code can only be associated with one SKU in your shop.unless you deleted your obsolete SKUs. -it should be numeric and less than 13 digits. -EAN code of Some Categories not required.Generally EAN code is a mandatory field and required to fill in. But some of the categories can be exempted.such as fashion related categories/dresses/shirts etc. You can leave it blank for those categories. But if you input an EAN code in this field. it should be unique in the store and the EAN code should be valid and real. |
Package Weight |
Indicate the weight of the package in kg. Please ensure you have entered the right package weight (kg) and dimensions (cm) to avoid incorrect shipping fee charges. |
Yes |
-'Standard delivery' and 'Express delivery' which means DBM delivery only supports: parcels less than 40 KG. (L+W+H)<300 and (L*W*H)/6000 <40. -Bigger parcels: please select 'Delivery by sellers' or apply DBS permission from your category managers. -Package value should be only number.And only two decimal allowed. |
Price |
Input your product price in local currency |
Yes |
- Only positive values are accepted |
Special price |
Indicate here if the product has an special price. it will be displayed as a sale price always. Please be careful to set this price. And we suggest you to manage special price with promotion tools in store. |
No |
-Special price is the promotion sale price. it should be lower than 'Price'. -If 'Special price' is empty.then it will be sold with 'price'. -If 'Special price' is maintained.the 'price' will be displayed as a crossed-out and not effective anymore. -Special price can't be too low. |
Package Length |
Indicate the length of your package in cm.Please ensure you have entered the right package weight (kg) and dimensions (cm) to avoid incorrect shipping fee charges. |
Yes |
-'Standard delivery' and 'Express delivery' which means DBM delivery only supports: parcels less than 40 KG. (L+W+H)<300 and (L*W*H)/6000 <40. -Bigger parcels: please select 'Delivery by sellers' or apply DBS permission from your category managers. -Package value should be only number.And only two decimal allowed. |
Package width |
Indicate the widht of your package in cm.Please ensure you have entered the right package weight (kg) and dimensions (cm) to avoid incorrect shipping fee charges. |
Yes |
-'Standard delivery' and 'Express delivery' which means DBM delivery only supports: parcels less than 40 KG. (L+W+H)<300 and (L*W*H)/6000 <40. -Bigger parcels: please select 'Delivery by sellers' or apply DBS permission from your category managers. -Package value should be only number.And only two decimal allowed. |
Package height |
Indicate the height of your package in cm.Please ensure you have entered the right package weight (kg) and dimensions (cm) to avoid incorrect shipping fee charges. |
Yes |
-'Standard delivery' and 'Express delivery' which means DBM delivery only supports: parcels less than 40 KG. (L+W+H)<300 and (L*W*H)/6000 <40. -Bigger parcels: please select 'Delivery by sellers' or apply DBS permission from your category managers. -Package value should be only number.And only two decimal allowed. |
Stock |
Indicate the stock of your product |
Yes |
- Only possitive numbers are accepted. -Please set the stock quantity greater than or equal to promotion booked stock plus existed unshipped order booked stock if there is any. |
Delivery by seller |
Indicate if the delivery of the product is in charge of the seller or Miravia.Only If this one is selected other delivery options will be disabled automatically. |
Yes |
-Only standard value 'Yes' or 'No' are allowed. Leave it blank will be treated as 'No'. Fillin 'Yes' here represented this item delivery by Seller; Fillin 'No' here represented this item delivery by Miravia. -Only permitted sellers can select DBS. If you want to select DBS please apply first from your category managers. Otherwise may result in failure of your create/update product process. |
Attribute Name 1 |
Indicate the different specifications of your product |
Conditional Mandatory |
-Attribute element contains name key and value pairs describing the product attributes. Map the available attributes per category in the List Category template. You can download it from the seller center. |
Attribute Value 1 |
Indicate the value of the attribute |
Conditional Mandatory |
-Attribute element contains name key and value pairs describing the product attributes. Map the available attributes per category in the List Category template. You can download it from the seller center. |
Attribute Name 2 |
Indicate the different specifications of your product |
Conditional Mandatory |
-Attribute element contains name key and value pairs describing the product attributes. Map the available attributes per category in the List Category template. You can download it from the seller center. |
Attribute Value 2 |
Indicate the value of the attribute |
Conditional Mandatory |
-Attribute element contains name key and value pairs describing the product attributes. Map the available attributes per category in the List Category template. You can download it from the seller center. |
Attribute Name 3 |
Indicate the different specifications of your product |
Conditional Mandatory |
-Attribute element contains name key and value pairs describing the product attributes. Map the available attributes per category in the List Category template. You can download it from the seller center. |
Attribute Value 3 |
Indicate the value of the attribute |
Conditional Mandatory |
-Attribute element contains name key and value pairs describing the product attributes. Map the available attributes per category in the List Category template. You can download it from the seller center. |
Attribute Name 4 |
Indicate the different specifications of your product |
Conditional Mandatory |
-Attribute element contains name key and value pairs describing the product attributes. Map the available attributes per category in the List Category template. You can download it from the seller center. |
Attribute Value 4 |
Indicate the value of the attribute |
Conditional Mandatory |
-Attribute element contains name key and value pairs describing the product attributes. Map the available attributes per category in the List Category template. You can download it from the seller center. |
Attribute Name 5 |
Indicate the different specifications of your product |
Conditional Mandatory |
-Attribute element contains name key and value pairs describing the product attributes. Map the available attributes per category in the List Category template. You can download it from the seller center. |
Attribute Value 5 |
Indicate the value of the attribute |
Conditional Mandatory |
-Attribute element contains name key and value pairs describing the product attributes. Map the available attributes per category in the List Category template. You can download it from the seller center. |
Attribute Name 6 |
Indicate the different specifications of your product |
Conditional Mandatory |
-Attribute element contains name key and value pairs describing the product attributes. Map the available attributes per category in the List Category template. You can download it from the seller center. |
Attribute Value 6 |
Indicate the value of the attribute |
Conditional Mandatory |
-Attribute element contains name key and value pairs describing the product attributes. Map the available attributes per category in the List Category template. You can download it from the seller center. |
Attribute Name 7 |
Indicate the different specifications of your product |
Conditional Mandatory |
-Attribute element contains name key and value pairs describing the product attributes. Map the available attributes per category in the List Category template. You can download it from the seller center. |
Attribute Value 7 |
Indicate the value of the attribute |
Conditional Mandatory |
-Attribute element contains name key and value pairs describing the product attributes. Map the available attributes per category in the List Category template. You can download it from the seller center. |
Attribute Name 8 |
Indicate the different specifications of your product |
Conditional Mandatory |
-Attribute element contains name key and value pairs describing the product attributes. Map the available attributes per category in the List Category template. You can download it from the seller center. |
Attribute Value 8 |
Indicate the value of the attribute |
Conditional Mandatory |
-Attribute element contains name key and value pairs describing the product attributes. Map the available attributes per category in the List Category template. You can download it from the seller center. |
Attribute Value 9 |
Indicate the different specifications of your product |
Conditional Mandatory |
-Attribute element contains name key and value pairs describing the product attributes. Map the available attributes per category in the List Category template. You can download it from the seller center. |
Attribute Name 9 |
Indicate the value of the attribute |
Conditional Mandatory |
-Attribute element contains name key and value pairs describing the product attributes. Map the available attributes per category in the List Category template. You can download it from the seller center. |
Attribute Value 10 |
Indicate the different specifications of your product |
Conditional Mandatory |
-Attribute element contains name key and value pairs describing the product attributes. Map the available attributes per category in the List Category template. You can download it from the seller center. |
Attribute Name 10 |
Indicate the value of the attribute |
Conditional Mandatory |
-Attribute element contains name key and value pairs describing the product attributes. Map the available attributes per category in the List Category template. You can download it from the seller center. |
Seller SKU |
SellerSku is more like an unique product identifier from seller internal operation or perspective. It is also an unique identifier for each product variation. |
Yes |
-Be aware that sellerSKU value cannot be duplicated in a store. Otherwise may result in failure of your create/update product process. -Please input less than 200 characters. -Leave it blank when updating products will be considered as no change. |
Parent SKU |
ParentSku is the original or main form of the product. If you're uploading a product with variants, it will group all the rows in one product. It is a non-buyable product used to relate SellerSkus. Item level product information will be read from ParentSku and not from SellerSku. |
Yes |
-Please input less than 200 characters. -Creating and updating products are mainly determined by different combinations of ParentSku and SellerSku: (1)When creating products: The same SPU with multiple SKUs should have a same ParentSku and the SellerSkus should be put as concecutive rows together. New SPU+SKU will be created as long as they are not existed ones in your store; (2)When adding Skus into an existing SPU: The new adding SellerSkus should not exist in your store. ParentSku is mandatory and the existing one; (3)When updating products: No need input parentSKU value. Only filling SellerSkus can update the existing SPU and SKU information. |
Pick up in store |
Indicate if the buyer can pick up the product in the store. |
No |
-This is the special service for buyer to pick up ordered goods in your offline stores. Pickup in Store only support for sellers who get the whitelist premission from Miravia. If you want to use 'Pickup in Store' please ask your person in charge to comfirm further informations. Otherwise may result in failure of your create/update product process. -Please input 'Yes' or 'No' . Empty value will be regarded as'No' (or regarded as no change when you update products). |
Delivery option standard |
Indicate if the product supports Standard delivery option. |
No |
-This is the Standard delivery option(DBM) for buyer whose service is provided by platform. It will set as default selection if there is no other options selected. -Parameter is invaild when you select Delivery by seller as your delivery option. -Only standard value 'Yes' or 'No' are allowed.Leave it blank will be treated as 'No'. But if there the DBS=No or blank, this option will be set as default 'Yes'. |
Delivery option express |
Indicate if the product supports Express delivery option. |
No |
-This is the Express delivery option(DBM) for buyer whose service is provided by platform. And the cost will be higher than standard one. -Parameter is invaild when you select Delivery by seller as your delivery option. -Express delivery is only for sellers with permission. Please apply it from your category manager. -Only standard value 'Yes' or 'No' are allowed.Leave it blank will be treated as 'No'. -When you select Delivery option express as your delivery option. Delivery option standard will be input 'No' by default. |
1)ean code is uniqe and can't be duplicated in your store.
2)Some categories need to be approved by Miravia before you can use them.Please contact with your category manager for more details.
3)Some brands need permission to be used. Please ensure the brand has submitted an application and obtained authorization and check with your person in charge in Miravia if you have any concerns.
4)When you migrating external images, the URL must include the prefix of "https://" when you migrating external images. And ensure that our system can get the correct format image from the url you fill in. Please pay attention that not URLs with ".jpg" or ".png" or ".webp" suffixes are necessarily valid URLs. The key is that our system can get the JPG/PNG/WEBP image from the url you fill in.
-An external image URL example:"https://cdn.mimaos.com/documents/images/products/395640-1.jpg".
5)Only Variation1 can set images. If you customize variants: which variant you set images for, this variant will be Variant1.
-For example, one product set two variant names: color family and size, if you customize size and set images for it, then size is Variant1. So images can be added to size instead of the default color family.
6)When there are multiple variants of the same product, the images of SPU and other SPU attributes only need to fill in the first line where the product name is located, no need to repeat them in the following sku lines. But if you want to fill in attributes of all the skus lines, please make sure all lines of same 'ParentSku' are the same.
After creating the files, you have to configure your server in order that Miravia can fetch the content. Please redirect to: Configuration of Automatic Feeds