Grouping and ungrouping product : Groupon Goods Marketplace

Regrouping and Ungrouping Products in Your Catalog

Regrouping and Ungrouping Products in your Catalog

If you have products in separate product groups that should be in the same product group, you will have to delete the products prior to adding them back into a new product group. If you do not delete and try to move them by changing the variation grouping ID, you will receive the error "Product Identifier Maximum allowed use of this Product Identifier has already been reached.".

Step One

Export your Full Catalog - this is very important. If you don't export your catalog first, you won't be able to access the product info later on. The catalog can be downloaded by clicking on the Full Catalog button on the Bulk Upload page.

Open the downloaded file in Excel.

When editing CSVs, Excel will automatically attempt to format the figures in your UPC column in Scientific Notation. To prevent errors, convert format to "NUMBER" or "TEXT" if there are any leading zeros.

Step Two

Delete the products in Gateway that you want to regroup.

Review this article for how to remove products or product groups.

Step Three

Make a copy of your full catalog that you exported in step 1. Then, to focus only on the products you are looking to edit, delete all rows except for those you are trying to regroup.

Then, change the Variation Grouping IDs to match the products you want to group. Ensure the Product Group fields match.

Note: For this to work the products that are being grouped need to have all product group fields exactly the same. For example: Category ID, Product/Product Group Title, Description, What's in the Box, Warranty fields, Manufacturer, Brand, Bullet Description, etc

Step Four

Save as a CSV and upload to Gateway.

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%

Regrouping and Ungrouping Products in Your Catalog

's Scorecard