In this tutorial you will learn about:
To update details about your offers, prices, or stock, you can use the 3 dedicated files available in the XLS Import section.
Update options:
- Update offers – for all offer-related modifications
- Prices – only for price modifications
- Stock – only for stock modifications
The Update offers file
What it contains: The “Update offers” file contains products that have a PNK in the platform.
What you use it for:
- Activating or deactivating offers
- Setting courier pickup days
- Updating prices and stock
How to fill it in: From column H – Sale Price begins the offer section where you can make modifications.
Important rules:
- Price: Must be without VAT. VAT must be the one set in the platform
- Status – set 0 to deactivate offers or set 1 to activate offers
- Currency: Must be in BGN or the currency set in the platform. Otherwise, the import will fail
- Stock: Is the number of units you actually have available for that product
- Minimum and Maximum Price:
- Minimum price must be less than or equal to the sale price
- Maximum price must be greater than the sale price
⚠️ Attention: If you try to make changes to the content section, these will be rejected because the file is only for offer updates.
💡 Tip: Check the sheets in the file for more information about completing the file.
Product improvement/rejected product modification (with PNK)
How to access:
- Go to section: Products → Product Categories → Product Content
- Next to the product category you want to update, download the XLS file “Improve product documentation”.
Sections contained in the file:
- Product Identification:
- Part Number Key (PNK)
- Product Code
- Category Name
- Category ID
- Product Name Validation
- Product ID
- Product EAN
- Documentation Information:
- Update Permission
- Product ready for site
- Product Description:
- Name
- Brand
- Source Language
- Description
- Own website URL
- Images:
- Main image URL + 5 secondary image URLs
- Variation (product families):
- Family ID
- Family Name
- Family Type
- Characteristics:
- Specific to each category
Modification permissions:
1.If “Update Permission” column shows “NO”:
- That product is associated with another product already existing in the platform
- You cannot modify the documentation
2.If you have permission to modify products:
- You can make changes in sections: Product Description, Images, and Characteristics
Approval process:
Depending on the complexity of modifications, these will be:
- Automatically Approved: Through platform verification. Status remains “Approved”
- Manually Verified: By an operator. Status changes from “Approved” to “Update in validation”
Examples:
- Characteristic marked as optional:
- Will be automatically verified
- Will be auto-approved by the platform without operator intervention
- Product name marked as mandatory:
- Will reach the list that operators will verify in the platform`s system.
⚠️ Important:
- Until update validation, if the product is active on the site, the initially approved documentation before the update will be displayed
- The update must comply with eMAG standards according to category to be validated
- Otherwise, modifications will be rejected and documentation returns to the initial version.
Rejected product improvement without PNK
Verification Process:
After uploading products, the platform will perform a preliminary verification to determine whether each individual product will proceed to validation by an operator.
When rejections occur:
When the verification system finds a situation that:
- Does not comply with eMAG standards
- Needs more information to approve that product
Result:
- You will see a feedback message displayed
- The product will reach status: “Documentation rejected” or “Rejected – fix errors”
“Rejected” status:
What does it means:
- The product did not receive PNK because it does not comply with eMAG standards
- To be validated, you must correct the error/add the requested information
- Until you correct it, you will find the product in the “Repair rejected products” file
Error example: photo_gallery: “Please correct the product’s main image and make sure it doesn’t contain an environmental background, other support elements, other products, zoom-ins, texts, collages, shadows or reflections and captures the product in its entirety, presented from the front.”
“Rejected – Fix Errors” Status:
When it appears:
- Content update is not consistent with the product where modification is desired
- The change is not justified
- The respective product content returns to its initial form
Error example: characteristics: test – “Values are not in the restrictive list. test”
For more information, please access the Message Center.
