Using the Price & Quantity File

When updating inventory, the Merchant Available Quantity (Quantity column on the file) should contain total units available to fulfill future orders (making sure to deduct any units already allocated to pending orders).

Updating your product inventory via bulk update allows you to update your inventory to multiple products at once and is similar to the Bulk Upload tool.

1. Go to the Bulk Upload page in Gateway

2. Click on the button marked "Price & Quantity" under the "Export" section in order to download your Price & Quantity file. Do not use the Full Catalog download if you are only updating price and/or inventory.

3. Open the downloaded .csv file in Excel.

4. Create changes to any product field(s) except for Merchant SKU. SKU is the unique identifier for products and if this field is changed, it will create an issue.

5. Please note that any changes to the Reference Price, Reference Price Type, or Reference Price URL fields will send the deal into pending review.

6. Save your file in the original .csv format.

7. Select the ".CSV" under Upload on the Bulk Upload page in Gateway and then select your saved .csv file.

8. The upload will produce a red cloud icon or green cloud icon under "Status". If a red cloud icon is present, your file has errors and needs to be revised. Any products not in the error file have been successfully uploaded. See Bulk Upload File Errors (https://marketplace.groupon.com/support/solutions/articles/5000770147-bulk-upload-file-errors) if your file has errors.

9. When products have been successfully uploaded, the "Status" column will show a green cloud icon. Your file was accepted and your products have been updated.

For more information about inventory, see Maintaining Your Inventory:

(https://marketplace.groupon.com/support/solutions/articles/5000796146-maintaining-your-inventory)

Did you find it helpful? Yes No

Metric	Description	Score	Goal
Overall Performance	Overall Scorecard Health		100%
Tracking Uploaded On-Time Rate	The rate at which orders receive a tracking number upload from the merchant within 2 business days of the order being placed.		>98%
Tracking Movement On-Time Rate	The rate at which an order's tracking number shows movement on the carrier's website within 3 business days of the order being placed.		>97%
Cycle Time	Average time elapsed between the date an order is placed, and the date that order is marked delivered.	Days	<6 Days
Customer to Merchant On-Time Response Rate	The rate at which tickets and messages created by customers receive a response within 1 business day.		>95%
Cancellation Rate	The rate at which orders placed are then cancelled by the merchant prior to tracking upload.		<0.5%
Return Rate	The rate at which successfully placed orders are returned/refunded after tracking has been uploaded.		<0.5%
Customer to Groupon Contact Rate	The rate at which orders received by the merchant result in customers contacting Groupon Customer Service.		<1.4%
Customer to Merchant Contact Rate	The rate at which orders received by the merchant result in customers opening a ticket to contact the merchant directly.		<3.6%
Customer Satisfaction Score	The rate of customers indicating satisfaction with their merchant’s customer service following a ticket being marked “Solved”.		>70%

Metric

Description

Score

Goal

Overall Performance

Overall Scorecard Health

100%

Tracking Uploaded On-Time Rate

The rate at which orders receive a tracking number upload from the merchant within 2 business days of the order being placed.

>98%

Tracking Movement On-Time Rate

The rate at which an order's tracking number shows movement on the carrier's website within 3 business days of the order being placed.

>97%

Cycle Time

Average time elapsed between the date an order is placed, and the date that order is marked delivered.

Days

<6 Days

Customer to Merchant On-Time Response Rate

The rate at which tickets and messages created by customers receive a response within 1 business day.

>95%

Cancellation Rate

The rate at which orders placed are then cancelled by the merchant prior to tracking upload.

<0.5%

Return Rate

The rate at which successfully placed orders are returned/refunded after tracking has been uploaded.

<0.5%

Customer to Groupon Contact Rate

The rate at which orders received by the merchant result in customers contacting Groupon Customer Service.

<1.4%

Customer to Merchant Contact Rate

The rate at which orders received by the merchant result in customers opening a ticket to contact the merchant directly.

<3.6%

Customer Satisfaction Score

The rate of customers indicating satisfaction with their merchant’s customer service following a ticket being marked “Solved”.

>70%

Using the Price & Quantity File

's Scorecard