Bulk Upload Tool : Groupon Goods Marketplace

Bulk Upload Tool

Instructions on how to use the Bulk Upload & Update tool

If you only read one thing... A Vendor SKU can only be used once in your catalog. If you try to add the same Vendor SKU again, it will move the item out of...

Thu, 19 Nov, 2020 at 3:22 PM

Bulk Upload Limits/Window

Gateway Bulk Upload Limits As a Marketplace merchant, you will be able to upload 15,000 rows per bulk file within a 12-hour window. This applies to all ...

Fri, 11 Jun, 2021 at 3:08 PM

Adding Product Attributes in the Bulk Template

Before we go over how to add attributes in bulk, here are some important things to note: All products that are created must have at least one attribute...

Wed, 16 Jun, 2021 at 4:16 PM

"Must only contain letters, numbers and the characters: .-,'!?:;()%/*@#{}$&~" Bulk Error

If you receive this error when trying to bulk upload your file, there are characters in your file that Gateway does not accept. Sometimes these characte...

Fri, 18 Jun, 2021 at 1:35 PM

Check Digit Information

In order for a Product Identifier to be valid, it needs to have a calculated check digit. A check digit is the last number in the Product Identifier that is...

Thu, 19 Nov, 2020 at 3:22 PM

Bulk File: Leading 0s Disappearing from Product Identifier

Due to the nature of Excel, leading zeroes on Product Identifiers, like UPCs, may disappear once the file is saved. Adding the zeroes and saving the file, t...

Fri, 18 Jun, 2021 at 1:32 PM

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...

Wed, 2 Jun, 2021 at 2:28 PM

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%

Bulk Upload Tool

's Scorecard