Importing Google product catalogs guidelines
Import items that you sell to non-US customers before requesting tariff code classifications.
Before you begin
- Column headings must be lowercase
- Description text must be in English
- Use underscores instead of spaces
- Values can't include the following characters:
- "
- ,
- /n
- / (in the ID or Description field)
About required fields
- Required
This field must have a value. - Conditional
This field only requires a value under specific conditions. See the Description column for when. - Recommended
This field isn't required, but we recommend adding a value for more accurate classifications. See the Description column for examples.
Download an example import file
| Column | Column heading | Required? (Character limit) |
Description |
|---|---|---|---|
| A | taxcode | Recommended |
Tax codes represent a unique product or service. Find tax codes in the Avalara Tax Code Search tool. P0000000 is used as a stand-in tax code for items that aren't mapped to an Avalara tax code. |
| B | price | Recommended |
The price of your product in the appropriate currency. Enter a numerical price and designate the currency by its ISO 4217 currency code.
|
| C | id |
Required (50) |
A unique value for each product that you sell. Typically the product SKU, but ecommerce platforms may require a different value.
Note: Do not include a / in ID values. |
| D | title |
Required (150) |
A short and accurate description of your product, including any distinguishing variations in material, color, or size.
|
| E | description |
Required (4000) |
An accurate description of your product.
Note: Do not include a / in Description values. Only English description text is supported. |
| F | product_type |
Required (750) |
The full category used to organize your product in your inventory.
|
| G | link |
Required (1000) |
A link to your product on a publicly accessible, verified domain. URLs should comply with RFC 2396 or RFC 1738. For example, a comma is represented as "%2C". URL is a very important field for visually identifying the product and providing a more accurate classification. Note: Links must be publicly accessible. If your product is not live, try to upload images to a cloud-based drive or storage location (such as Google Drive or Dropbox) and generating a link that is accessible to an external user. |
| H | image_link | Required |
A link to an image of your product on a verified domain. |
| I | condition | Recommended |
The condition of your product at the time of sale.
|
| J | coo | Recommended |
The country of origin. Enter countries by their two-letter ISO code.
|
| K | hs_hint | Recommended | If you already know the tariff code or HS6 designation, add it to this column. |
| L | hs_code_test | Recommended |
This value is used in preproduction testing to verify that Avalara's tariff code assignment functionality is working properly in your sandbox environment. Items aren't classified for sandbox accounts. |
| M | google_product_category | Recommended |
The product category as defined by Google's product taxonomy.
|
| N | availability | Recommended |
Your product's availability.
|
| O | sale_price | Recommended |
The price of your product when on sale.
|
| P | sale_price_effective_date |
Recommended (51) |
Only necessary if Sales Price contains a value. Separate start and end dates with a /.
|
| Q | gtin |
Recommended (50) |
The product's global trade item number. Added spaces and dashes are ignored
|
| R | brand |
Recommended (70) |
The brand name of the product.
|
| S | mpn |
Recommended (70) |
The product's manufacturer part number as assigned by its manufacturer.
|
| T | material |
Recommended (200) |
The primary product material. For materials that have primary and secondary materials, separate up to three materials with a /.
|
| U | shipping | Recommended |
The shipping method associated with the product or purchase. Shipping values should include the country, shipping service, and shipping price.
|
| V | color |
Recommended (100) |
The color of your product. Separate multiple colors with a /, listing the primary color first.
|
| W | to_classify | Ignore this field |
You don't need to add values to this field. This is an internal field that is not used to classify your item during an import. After your import is complete, request classification for your items in Settings > What You Sell. |
| X | item_group_id |
Conditional (50) |
A unique value for an item group containing multiple variants. Use item group IDs for sets of products that differ by color, size, pattern, material, age group, or gender. This isn't required if the item isn't part of a group of variants.
|
| Y | gender | Conditional |
A gender designation that normally applies to gender-specific clothing. This isn't required for items without a gender designation, such as furniture.
|
| Z | age_group | Conditional |
An age designation that normally applies to age-specific clothing. This isn't required for items without an age group designation, such as furniture.
|
| AA | size | Conditional |
The size of your clothing products. If it has multiple dimensions (Ex: neck and sleeve measurements), combine them into a single value. This isn't required for items without a size designation, such as furniture.
|
| AB | shipping_weight | Conditional |
The weight of the product. This information is required in some jurisdictions. Weight values can be 0-2000 lbs or 0-1000 kgs.
|
| AC | shipping_weight_UOM | Recommended |
The primary unit of measurement used for this product's weight.
|
| AD | is_preferred_program | Recommended | True or False |