Attributes in the Bulk Template : Groupon Goods Marketplace

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 value, even if it is the only product in a group
Some categories have particular attributes that are required in order to create products
If there is more than one product in a group, there must be at least one Distinguishing Attribute to tell the difference between products (eg different colors, different sizes)

1. Once all other information has been provided in the Bulk Upload Template, navigate to the end of the spreadsheet where the "Attribute Name" and "Attribute Value" columns are located. Here you will enter attributes for each product.

2. Click on the Attributes tab and search for the product category to see what attributes are available and which attributes are required for your product(s).

3. Enter the attribute(s) noted in the Attributes tab into the "Attribute Name" column that matches your product's row, either by copying/pasting or choosing from the dropdown provided. Each attribute should have it's own "Attribute Name" cell. For example, if there are the attributes "Men's Apparel Size" and "Color" that are required for a category, "Men's Apparel Size" would be entered under "Attribute 1 Name" and "Color" would be entered under "Attribute 2 Name".

4. Enter the corresponding attribute value for each attribute under the "Attribute Value" column that matches the products row. Each attribute value should have it's own "Attribute Value" cell. For example if the attribute names "Men's Apparel Size" and "Color" have already been provided as "Attribute 1 Name" and "Attribute 2 Name", then "Small" would be entered under "Attribute 1 Value" and "Green" would be entered under "Attribute 2 Value". If you are unsure what attribute values are accepted, reference the Attribute Values tab of the Bulk Upload file or use the drop-down provided to choose a valid attribute value.

5. Confirm that each product in each product group (designated by the Variation Grouping ID) has their own unique set of attribute values. For example, no two products both have "Green" and "Small" as their unique attribute value set.

For more information about Attributes and Deal Page Drop-Downs, see Attributes & Traits (Drop-Downs) Relationship.

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%

Adding Product Attributes in the Bulk Template

's Scorecard