Set Up Product Feeds

This information refers to SuiteCommerce or the 2019.2 release of SuiteCommerce Advanced or later.

Before you start to create your product feed using the SuiteCommerce Product Feeds extension, you must first set up the service where you want to use the product feed and identify the requirements for the data feed. You also need to update your item records with the required information for the product feed type.

You can create product feeds that contain the following item types:

• Inventory items (and matrix items)

• Non-inventory items (and matrix items)

• Kit/Package items

• Assembly items (not including the component items)

• Download items

• Gift certificates

Important:

SuiteCommerce extensions are only available if they are provisioned and set up in your account. For more information, see Commerce Extensions.

Required Features

Before installing Product Feeds, check that the following features are enabled in your NetSuite account.

• Items & Inventory subtab:

  • Matrix Items

  • Inventory

• Transactions subtab:

  • Promotion Codes

  • SuitePromotions

• Commerce subtab:

  SuiteCommerce or SuiteCommerce Advanced

• SuiteCloud subtab:

  • Custom Records

  • Server SuiteScript

  • Create Bundles with SuiteBundler

• CRM subtab:

  Mail Merge (optional)

• Company subtab:

  Inline Editing (optional)

Installation

The SuiteCommerce Product Feeds extension does not require activation for a specific website or domain. However you need to install the SC Product Feeds SuiteApp. For more information, see Installing Theme and Extension SuiteApps.

To install the SC Product Feeds SuiteApp:

1. In NetSuite, go to Customization > SuiteBundler > Search & Install Bundles.

2. In the Keywords field, enter the Bundle ID or ‘product feeds’ and click Search.

3. Verify that the SC Product Feeds SuiteApp is returned in the search and select it.

4. Review the SuiteApp details and then click Install.

Update Product Feed Fields

When you install the SuiteCommerce Product Feeds extension, product feed-specific fields are added to the Feeds tab in your Item records to collect product-feed specific information. For a list of the fields added to the Item record, see Product Feed-Specific Fields.

Important:

Required fields for the target product feed type must not be left blank in the Item record. Otherwise, an error will be triggered in the service when you upload the product feed.

According to the product feed type you want to create, these attributes are considered either mandatory or optional for the item and vary from merchant to merchant.

• Google Shopping

• Google Merchant Promotions

• Facebook Dynamic Ads

• Other Services

You can update these fields manually on each individual Item record, use the Mass Update menu option, or use CSV import.

Google Shopping

Product feeds to be imported into the Google Merchant Center should contain at least the following fields:

• ID

• Title

• Description

• Link

• Image link

• Availability

• Price

• Condition

• Google product category

Other attributes may be required depending on the item type to be included and the target country of the product feed. For more information on the specific requirements for your feed, see the Google Shopping Product Specifications.

Google Merchant Promotions

Product feeds including promotion information to be imported into the Google Merchant Center should contain at least the following fields:

• Google Shopping fields, and

• Promotion ID

• Product applicability

• Offer type

• Long title

• Promotion effective dates

• Redemption channel

All the required attributes are mapped to existing fields in the Promotion record in NetSuite. For a list of the attributes that can be provided in the promotion feed, see the Merchant Promotions feed specifications.

Facebook Dynamic Ads

Product feeds to be imported into a Facebook Catalog for Dynamic Ads should contain at least the following fields:

• ID

• Availability

• Condition

• Description

• Image link

• Link

• Title

• Price

• GTIN, MPN, or brand

Other attributes may be required depending on the item type to be included. For more information on the specific requirements for your feed, see Facebook Product Catalog Specifications.

Other Services

SuiteCommerce Product Feeds can also be used to create a custom CSV output, which can be used as a data feed for other marketplaces, shopping channels, and product comparison search engines. The attributes required for these services vary according the product type to be included. You should verify the fields required for each specific case before updating the Item record.

To update the product feed fields using Mass Update:

1. Go to Lists > Mass Update > Mass Updates.

2. Enter a description for the mass update in the Title of Action field.

3. Filter the items using advanced search criteria.

   For example, you can restrict item selection by using name as a filter, setting contains as the name, and entering an item keyword. For more information on how to filter items in Mass Update, see Advanced Search Criteria Filters.

4. On the Mass Update tab, enter the values for all the product feed-specific fields you want to update on the Item record.

   For example, you may want to update the Category field to contain the Google product category. Select the Category box, and then enter the percent sign (%) and a keyword such as apparel to display all categories containing the keyword apparel.

5. Click Save.

You may need to repeat this operation several times to update all the fields for the items you want to include in your product feed. For more detailed information on setting up the Mass Update to update item fields, see Defining a Mass Update.

To import using CSV import

1. Go to Lists > Search > Saved Searches > New.

2. Restrict the search using Advanced Search Criteria Filters to retrieve the items you want to update.

3. Click Preview.

4. In the list of search results, click Export — Microsoft Excel and save the export file.

5. In the resulting export file, change the fields you want to update as required.

6. Save the product catalog export file in CSV format.

7. Go to Setup > Import/Export > Import CSV Records.

8. Import the updated product catalog file.

   For more detailed information on how to import data using the Import Assistant, see Importing CSV Files with the Import Assistant.

Next Steps

When you have updated the Item record with all the required and the optional fields, you are now ready to create a product feed.

• Create a Product Feed: Set up a data feed for Google Shopping, Facebook Catalogs, or in CSV format.

• Create a Promotion Feed: Set up a data feed for use in Google Shopping with Merchant Promotions.

Related Topics

Create a Product Feed

Create a Promotion Feed

View the Feed Status

Product Feeds

General Notices