Shopzilla
Use the product feed results in NetSuite to create a datafeed file for Shopzilla's Merchant Listings Service. You must create an account with Shopzilla to upload the file. Visit merchant.shopzilla.com for information about pricing and setup.
According to the requirements from Shopzilla, your file must not exceed 1 MB. If it does, you must submit your product feed in multiple files. Shopzilla processes data feeds every 36 to 48 hours. For the complete list of requirements from Shopzilla, read Shopzilla's product inventory specifications.
To upload your product feed file to Shopzilla:
-
Log in to your Shopzilla account.
-
Select the Product Listing tool and choose FullList.
-
Browse to the product feed file on your computer to upload the file to Shopzilla.
The table below shows the columns displayed in your NetSuite product feed results and the columns that are required by Shopzilla. All 15 columns are required in the datafeed. Please note that some columns, as indicated below, cannot be left blank.
Do not delete any of the columns or change the order. This causes your datafeed to fail when you try to submit it.
|
NetSuite |
Shopzilla |
Notes |
|---|---|---|
|
Category |
Category ID* |
This column must contain data. Data for this field is mapped from the Shopzilla Category ID field on the Store subtab on the Item record. Shopzilla's category IDs are displayed on Shopzilla's category list. |
|
Manufacturer |
Manufacturer* |
Enter data in the Manufacturer field on the Basic subtab of Item records. |
|
Title |
Title* |
This column must contain data. The value for this field comes from the Item Name/Number field on the Item record. |
|
Description |
Description* |
The value for this field comes from the Detailed Description field on the Store Subtab of the Item record. Do not use HTML or control characters in the data feed you send to shopzilla. Also, do not use promotional language such as “free shipping” or “sale item”. |
|
Link |
Product URL* |
This column must contain data. The URL displayed in product feed results is a link to the item in your web store. |
|
Image |
Image URL* |
The URL displayed in product feed results is the link to the image associated with the item in your web store. |
|
SKU |
SKU* |
This column must contain data. SKU stands for Stock Keeping Unit and is a unique designator for each listing in your feed. Each product in your feed must have a different SKU listed. |
|
Quantity on Hand |
Availability* |
This field lets your consumers know if the product is currently available on your website. Acceptable values for Availability:
|
|
Condition |
Condition* |
Use this field to designate the state of the product. Acceptable values for Condition:
|
|
Shipping Weight |
Ship Weight* |
This field is used to designate the weight of your product (in pounds). This field is required if your store's shipping costs are determined based on an item's weight. |
|
Shipping Cost |
Ship Cost* |
This field is used to designate a flat shipping cost for the product, if desired. This field is not necessary if you plan to use the Shopzilla Shipping Tool to specify ship costs. Note:
|
|
|
Bid* |
This is an optional field and recommended only for those merchants programmatically setting their product bids. The NetSuite product feeds results do not include this column by default. For more information, see Editing Product Feed Results. |
|
|
Promotional Code* |
This field is used to add promotional text next to your product. For a detailed list of valid promotional codes, visit Shopzilla's product inventory specifications. The NetSuite product feeds results do not include this column by default. For more information, see Editing Product Feed Results. |
|
UPC |
UPC* |
UPC stands for Universal Product Code. UPC numbers have 12 digits, and are found with bar codes on product packaging. |
|
Price |
Price* |
This column must contain data. Product feed results in NetSuite display the online price level as defined on the Web Site Setup form. If you use NetSuite OneWorld, and you choose a subsidiary in the list at the bottom of the product feeds page, the price displayed is the default currency for the subsidiary. |