Create Products and Offers
Store Setup
As a new seller, creating Products and Offers is essential. Understanding the differences between products and offers and how to efficiently upload your store’s offerings are important steps to get started.
In this article:
- What is the Difference Between a Product and an Offer?
- Methods to Upload your Products and Offers
- Creating a Single Product and Offer
- Creating a New Product and Offer for a Single Item
- Creating New Products and Offers for Multiple Items
- Create Offers for Existing Products
- How to Track Your Imports
- Product and Offer Attribute Descriptions
- Create Products and Offers via API
PRODUCT: The product is the actual content associated with a listing on Bestbuy.com. It contains all product attributes and “fixed” information such as:
- Product name
- Short and long description
- Color
OFFER: The offer is the price and inventory associated with the product. This information (unlike the product) changes frequently such as:
- Selling price
- Stock quantity
- Inventory number
Depending on the size of your product assortment, you can choose one of three methods to create new products and offers.
- For adding fewer than 20 products to the Marketplace, you can upload each one manually via single product creation.
- For adding more than 20 products, it is recommended to upload your assortment in bulk using an Excel template.
- To automate the process, consider using one of the connectors available through Mirakl Connect or refer to Mirakl’s API documentation for custom API usage.
Recommended for uploading less than 20 products
To get started, once you’re in the Best Buy Marketplace portal, go to: Price and stock > Offers > click
From here, you have two options:
Option 1 – Product Already Exists in Best Buy’s Catalog
You can select “Search for a Product in our Catalog” to browse through existing products. Once you've found the product that you'd like to add an offer to, follow steps to Create Offers for Existing Products.
Option 2 – Product is New to Best Buy’s Catalog
If your product does not currently exist in our catalog, select Create a Product and follow the instructions below.
- To start the product creation process, select your primary category and any additional child categories from the dropdown menu(s).
- The product characteristics related to the category will appear below. Mandatory fields have a red asterisk (*). Please note product characteristics vary by category and Best Buy’s Data Standards must be followed; see Product Attribute Descriptions (subsection below) for more information.
- Enter transactional information related to this product under offer characteristics. Note that condition, stock quantity, and price are mandatory.
See Offer Attribute Descriptions (subsection below) for information on remaining optional fields.
- Once you’ve completed entering the details of your product and offer, select the button
.
- When a product is new to Best Buy’s Catalog, it may show as Pending or Awaiting Product Creation until the Best Buy team takes action. Work with your account manager for more information.
Excel bulk upload - Recommended for uploading more than 20 products
- To download a template, go to: Price and stock > File Imports > click the link for the Excel template under Products and Offers.
You will land on a new page to set up your template.
- Under Template type, choose one of three options:
- Product: To download a template for product creation only.
- Offer: To download a template for offer creation only.
- Products and Offers*: To download a template that contains both product and offer information.
*If this is your first upload, we suggest downloading this template.
- Product: To download a template for product creation only.
- Under Requirement level, choose one of three options:
- All*: Contains all product attributes for that category. *We suggest providing as much information as possible about your products as it helps customers make a buying decision.
- Required: Contains only required attributes for that category.
- Required and recommended: Contains required and recommended attributes for that category.
- All*: Contains all product attributes for that category. *We suggest providing as much information as possible about your products as it helps customers make a buying decision.
- Under Categories, select or search for your product category.
Note that we recommend selecting & working on one category at a time. Required, recommended, and optional attributes vary by product category.
If you have multiple product types within a category, you can select the parent category so that all child categories are available in your template. You will assign the child category for each product in step 7.
For example, if you have several types of products in Networking, you may want to select Networking. If you only have Mobile_Hotspots and Network_Routers, you can generate a template for only those two.
- At the bottom, select
.
- Once complete, your template will appear at the top of the page. Click Download.
- Open the downloaded file and in Column A, use the dropdown menu to select the appropriate category.
Once your category is selected, you may see the attribute fields change color:
If you take a quick scroll to the right, you will notice there are columns in green or blue:
- Fill in all applicable attributes. See Product and Offer Attribute Descriptions (subsection below) for more information.
- Once you have completed and saved your template, import it into the /Mirakl Back Office:
- Go to: Price and stock > File imports > Import File
- Select the following criteria to upload your file:
- Source – Select the file from your computer
- File Content – Offers AND Products
- Import Mode – Normal
- Note, you should always use Normal import mode when adding or updating products
- Select Import when ready to upload.
- See How to Track Your Imports (subsection below) for next steps
- If a product is new to Best Buy’s Catalog, it may show as Pending or Awaiting Product Creation until the Best Buy team takes action. Work with your account manager for more information.
- If a product is new to Best Buy’s Catalog, it may show as Pending or Awaiting Product Creation until the Best Buy team takes action. Work with your account manager for more information.
If your product(s) already exist in the Best Buy Marketplace Catalog, you can skip steps for product set up and add your offer to the existing product. See Create Offers for Existing Products.
What happens after I upload my Products and Offers?
To see the status of product and/or offer uploads, go to:
Catalog > Product Imports or Price and stock > File Imports > Track Offer Imports
If you encounter any errors during the process of importing product and offer uploads, please refer to Mirakl’s help articles for guidance.
Product Attribute Descriptions
Required product attributes vary by product category. Best Buy’s Data Standards must be followed when filling out all product attributes; see Global Product Data Standards for more information.
Offer Attribute Descriptions
* = mandatory |
|
|
---|---|---|
In Mirakl 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. See the Best Buy Marketplace Secondary Products Guidelines for more information. |
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. See Promotional Offers using Discount 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.
|
Availability | 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-description | 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.
To see a list of connectors and API integrations to help automate this process, see Mirakl’s help articles on Seller connectors and/or API documentation.