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, then uploading to Gateway without opening the file again can solve this issue.

1. Open the bulk file and navigate to the Product Identifier column.

2. Insert a new column to the left of the Product Identifier column and title the new column "Product Identifier" also.

3. In the second row of the column, enter the formula "=CONCATENATE("0",[cell name]), where [cell name] is the cell letter and number, and press enter.

4. Continue this formula for all rows that have Product Identifiers without their leading 0s.

5. Once all formulas have been entered, highlight the new column and copy. Click into the first cell of the column, right click, and choose Paste Special > Values.

6. Delete the original Product Identifier column.

You now have a proper Product Identifier column with leading zeros attached. Once all desired changes have been made, save your file and upload using the Bulk Tool without opening the file again before uploading.

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%

Bulk File: Leading 0s Disappearing from Product Identifier

's Scorecard