How Do I Fix “Duplicate Universal ID” Error

Cause of “Duplicate Universal ID” Error

In Excel, your Product Identifier will automatically be formatted in scientific notation. This means a value entered as “855031021476” becomes formatted as “8.55031E+11”.

Since this formatting will be rejected by the Bulk Upload tool, you will need to change your Product ID cells into number format. Take the steps below, then re-upload to the Bulk Tool.

Resolving “Duplicate Universal ID” Error

1. Highlight all cells containing Product Identifiers.

2. Find the dropdown menu above your spreadsheet, in the section labeled “Number”.

3. Open this menu and change the formatting for your highlighted Product Identifiers from “General” to “Number”.

4. Use the “Decrease Decimal” button below the formatting drop-down to decrease the number of decimal places to zero, giving you a whole number with no numbers following a decimal place.

(example: 855031021476 instead of 855031021476.5452 ).

If this does not resolve your error, try following the steps in the Leading 0's Disappearing

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%

How Do I Fix “Duplicate Universal ID” Error

's Scorecard