Create Offers for Existing Products
There might be instances where the product you intend to sell is already a part of the Best Buy Marketplace catalog, refer to the below information to learn how to save time by adding your product offer using an existing product profile.
Note: If you need to create a new product, see Create Products and Offers.
In this article:
- Upload a single offer
- Upload multiple offers
- Set Up Promotional Prices
- Check offer upload status
- Editing or Cancelling an Offer
- Offer Attribute Descriptions
- Resolving offer import issues & errors
To add a single offer to an existing product, follow these step-by-step instructions:
- Log in to the Marketplace portal and navigate to the Price and stock section.
- Click on Offers, then find and select the + Add Offer button located at the top right of the page.
- Under Search for a product in our catalog, enter the product's name, brand, model number, UPC, or SKU to locate the product you want to list.
- Once you've found the product, select + Sell Yours.
- Complete the required fields of condition, stock quantity, and price.
- The remaining fields are optional. See Offer Attribute Descriptions (subsection below) for more information.
- The remaining fields are optional. See Offer Attribute Descriptions (subsection below) for more information.
- Finally, click Create Offer to submit your offer.
To add multiple offers to existing listings using a bulk upload method, follow these step-by-step instructions:
- Log in to the Marketplace portal and navigate to the Price and stock section.
- Under File Imports, download the Excel template under Offers on the right side of the page.
- After downloading, select Generate Template. Once it's ready, click Download.
- Open the downloaded Excel template and fill out the mandatory fields for your offers.
See Offer Attribute Descriptions (subsection below) for more information.
Note that quantity is optional, but highly recommended. Leaving it blank will default your quantity to 0 and offers will be deactivated due to out of stock.
- Once you've completed the template, save it to your computer.
- Return to the Marketplace portal, go to Price and Stock, and click on File Imports.
- On the Import file tab, under Source, select the file you just filled out. Ensure File content is set to Offers and Import mode is set to Normal.
- Finally, click Import to add the offers.
Use the discount fields when setting up an offer to display additional savings. See Promotional Offers using Discount Price for more information.
You can check the status of your offers after uploading them to the Marketplace portal. Navigate to File Imports to see the status of your uploads under Track Offer Imports.
An error report will be available for download if there are any issues with your file. See Resolving Offer Import Issues & Errors (subsection below) for more information on common errors.
Successful offer imports for existing products are approved immediately. Please note that active offers in your Mirakl Back Office may not always be reflected on bestbuy.com if multiple sellers have offers on the product.
- Log in to the Marketplace portal and navigate to the Price and stock section then Offers.
- Use the Filter section to find your offer by Offer, Product, or Catalog filters then click Refresh.
- On the far right of the offer, click the “…” to see more options. Select either Edit price or Delete offer.
- Within Edit price, you can change the price, discount price, and/or discount validity periods.
- Important Note: Do not edit the condition or state of an offer. If you need to change this, you must delete the offer and create a new one.
|
* = mandatory |
|
|
|---|---|---|
| In Back Office (Single Item) | On Excel Template (Multiple Items) | |
| Offer SKU | SKU * | The offer’s unique identifier. This is not surfaced during the shopping experience. |
| -- | product-id * | SKU, UPC, or Shop_SKU |
| -- | product-id-type * | Select the corresponding product ID type that you filled for Product ID from the dropdown list. Most common: UPC. |
| Stock Quantity * | quantity ** |
The quantity you have in stock and ready to ship. **On the template, this is optional but highly recommended. Leaving it blank will default your quantity to 0 and the offer will be inactive. |
| Condition **** | state **** |
This refers to the product condition. Select New or Refurbished – Excellent from the dropdown menu. |
| Description | description | Offer description. This is not surfaced during the shopping experience. |
| Price * | price * | Product selling price |
| Discount Price | discount-price |
Use this field if you have any additional savings on your selling price. |
| Discount Period | discount-start-date discount-end-date |
Use these fields if your discount is for a limited time only. If no date is specified, the discount is applicable immediately and/or indefinitely. |
| Lead time to ship | leadtime-to-ship |
Use if a product’s lead time to ship differs from your store default. Please note, a maximum of 2 days still applies.
|
| Availabilty | available-start-date available-end-date |
Use if your offer has a set start and end date. If no date is specified, the offer is applicable immediately and/or indefinitely as long as stock quantity > 0. |
| Quantity Alert | min-quantity-alert |
The minimum stock level that triggers an email alert. No alerts are sent if this field is not specified. |
| Internal Description | internal-descriptiont |
Additional information for reference. This is not surfaced during the shopping experience. |
| Price Information | price-additional-info |
Additional information for reference. This is not surfaced during the shopping experience. |
| Logistic Class | logistic-class |
If your product is a different size than the default logistics class for the product category, you can change it using the dropdown menu. You can edit this once the offer is created. |
| --- | update-delete |
Only use with ‘Normal’ upload mode. If this field is set to update or is blank, a new offer will be created if the SKU field does not match any existing offer of your store. If the SKU field matches an existing offer, the offer is updated. |
*** Important Note about Offer Condition or State - This value cannot be changed after an offer is created. If you need to change the offer state, please end the existing offer and create a new one.
- In the left menu bar, go to Price and stock / File imports and then to Track Offer Imports.
- Hover over the "i" icon to see details of the import. (Refer to screenshot below). Click on the menu icon to download the Error Report. The errors are listed in the last columns of the row in the Excel file.
- Any lines that have errors represent offers that were not added/updated to the product. Please refer to Mirakl’s help articles for any additional guidance.
