Here we will show you how to upload an offer through the file generated by the platform. This method is the most used to synchronize offers, especially when they are massive, and it is the one we recommend if you do not have it automated by API.
Location: "Prices and stock" - "File imports".
URL: https://pccomponentes-prod.mirakl.net/mmp/shop/import
In this location, you will see several options, including uploading a file, specifying the file you are going to upload, and the import mode. Now we will focus on downloading the template, and for that, we will click on "Excel Template" in the "Offers" sub-section.
On the next screen, you will be given the option to choose the type of template and the language in which you want to download it.
|
Click the blue "Generate template" button, and the option to download it will appear in the "Last generated templates" sub-section.
Open the downloaded file. The pink fields are mandatory, and the white ones are optional. We indicate how to fill in each field:
Offer SKU: Your internal identifier.
Product ID: The item identifier, with which you will synchronize the offer, according to the option chosen in the next column. (We recommend using EAN).
Type of product ID: In the dropdown, select the identifier with which you will perform the synchronization.
Offer description: This field is not necessary to fill in unless it is a refurbished product, in which case, you will indicate the condition of the item.
Internal offer description: Description visible only to you. It is not necessary to fill in this field.
Offer price: The price of the item including VAT.
Additional information about the offer price: Additional price information. It is not necessary to fill in this field.
Offer quantity: The stock of your product.
Minimum quantity alert: The system will notify you when you reach the quantity you set in this field.
Offer status: Specify if it is a new item, or any of the three refurbished states we currently have, in the cell itself there is a dropdown.
Start date of availability: The start of the item's availability (The format must be: 22/03/2024 0:00:00).
End date of availability: The end date of the item's availability (The format must be: 22/03/2024 0:00:00).
Logistics class: Choose the logistics class of your product in the dropdown. This will help you configure its shipping times.
Favorite range: We do not use this field. It is not necessary to fill it in.
Discount price: Final price of the item with discount. VAT included. (When this field is filled in, the crossed-out price will be the one in the "Offer price" field).
Start date of the discount: Initial date of the item's discount (The format must be: 22/03/2024 0:00:00).
End date of the discount: Final date of the item's discount (The format must be: 22/03/2024 0:00:00).
Update/Delete: This field would only be used to update or delete a file in Normal import mode. If left blank, it would be considered an update upload.
The following options are shown for you to upload your files related to the circular economy. Only for France.
Free Return: Indicate if you offer free return to the customer or not in the dropdown.
Canon: Here put the number "0".
VAT TYPE: Put "21".
|
To upload the file, return to the initial screen: "File imports". In "File content" select "Offers" (Usually already selected by default). In import mode, choose the one that best suits your needs. We advise you to use, most of the time, the "Normal" mode.
Normal: You can create, update, delete offers, depending on what you have chosen in the previously described field "Update-delete".
Delete and replace: The file you upload with this mode will delete all previously uploaded data and replace it with this last file. It is useful if you want to make massive deletions or changes.
Now that you have synchronized your offers, you can track them by clicking on the "Monitor offer import" tab. You will see the status of their synchronization.
On the right, the information will appear in the gray information circle. If you hover over it, you will see the total upload summary and if there were any errors. In case of errors, in the "Errors" field, you can download the report indicating the reason for the error so you can fix it.