Knowledgebase: Marketing
How do I use the Shopzilla/BizRate Feed Export?

Shopzilla / BizRate Export

Note
You will need to have a Shopzilla / BizRate account before proceeding with the process. If you do not have a Shopzilla / BizRate account, you can sign up for one by clicking here.


Customize your Shopzilla / BizRate Feed

Your 3dcart store will generate a the product feed using default attributes used by Shopzilla / BizRate for a successful upload. If you'd like, you may review and edit the feed as needed using the following steps:

  1. Log into your 3dcart Online Store Manager
  2. Use the left hand navigation menu and go to Marketing ->Shopping Engines
  3. Look for the "Shopzilla / BizRate Export" section located on the right hand side of the page
  4. While viewing the Shopzilla / BizRate Export Plugin, click on the "Customize" link.

How shopping feed plugins work
It's important to note that 3dcart's Shopping Engine plugins are set to generate an export of your products via a pre-built custom CSV export. This custom export is tailored to match the individual shopping engine's default attributes; renamed and ordered in the style that the shopping engine uses.

For example, your 3dcart store will normally export an individual product's weight as "weight" whereas Shopzilla / BizRate refers to the attribute as "Shipping Weight " The custom export used by the Shopping Engine plugin will take "weight" and generate a feed with the label "Shipping Weight" instead.

For the most part, the default feed has everything you'll need for a successful export, so you won't have to edit the custom feed at all. The ability is there if needed, however. So, let's have a look at the applicable areas of the customize feed page.

Add Export Field

At the very top of the page, you will see the "Add Export Field" section. While the default feed is structured to have the appropriate attributes already added, you may add more as needed.

  • Add New Field
    This drop down menu will let you add a product attribute from the 3dcart store's database to your shopping engine feed.
    Simply select the necessary attribute form the drop down menu (for example, stock) and click on the "+Add New" button to have it added to the list.

Update Export Parameters

Below the Export Field section, you will find the Update Export Parameters section. This area of the page allows you to specify some of the formatting used on the resulting feed. These settings should usually be left untouched but can be changed if/when needed. Your choices here are as follows:

  • Set Name
    The name of the custom export set that will be used for the feed.
    Under normal circumstances you will not need to change this.
    The default entry for Shopzilla / BizRate is "shopzilla"
  • Delimiter
    The data delimiter used by the Shopping Engine.
    Each shopping engine has its own required formatting for how data is separated.
    Your choices in this drop down are:
    • Default & Comma Delimiter
      Both default and comma delimiters will use a comma (,) to separate each data entry.
    • Tab Delimiter
      This will use a tab to separate each data entry
      For Shopzilla / BizRate, the default is Tab Delimiter
    • Tilde Delimiter
      This will use a tilde (~) to separate each entry.
  • Category Separator
    If the feed uses category listings, this setting will let you control how Parent Category/Sub-categories relationships are displayed. Your choices are:
    • / (forward slash)
      Categories will be displayed as "ParentCategory/SubCategory"
    • > (close angle bracket)
      Categories will be displayed as "ParentCategory>SubCategory"
      This is the default for Shopzilla / BizRate
    • - (hyphen)
      Categories will be displayed as "ParentCategory-SubCategory"

Export Fields

Finally, at the very bottom of the page, you will see the actual export fields and how they will be formatted when the feed is generated. The listing will be shown with the following columns:

  • Field
    The name of the product attribute as it appears on the 3dcart database.
    Again, using product weight as the example, we call it "weight"
  • Alias
    The name of the product attribute as it will appear on the resulting feed.
    This is usually the designation that the shopping engine wil use.
    Again, using product weight as the example, Shopzilla / BizRate will refer to it as "Shipping Weight "
  • Prefix
    Information entered here will be added to the start of the respective product attribute
    For example, some shopping engines may require prices to be displayed with the appropriate currency symbol.
    In these cases you would enter the currency symbol as the prefix so that the resulting export displays $0.00.
  • Suffix
    Information entered here works the same way as the Prefix except it will be added to the end of the data
  • Order
    This column is where you can set the sroting order for the resulting feed's data.
    The higher the number, the farther it will appear in order.

At the far right of each entered field, you will see its respective Action Wheel which will give you the option of deleting the field as needed.


Generate Feed

After setting up and customizing your Shopzilla / BizRate feed as needed, you can generate it for upload to your Shopzilla / BizRate account.

  1. Log into your 3dcart Online Store Manager
  2. Use the left hand navigation menu and go to Marketing ->Shopping Engines
  3. Look for the "Shopzilla / BizRate Export" section located on the right hand side of the page
  4. While viewing the Shopzilla / BizRate Export Plugin, click on the "Generate Feed" link.

The store will generate the feed and give you the option to:

  • Download
    The "Click here to download the exported file" link will download the generated file to your computer.
    This file may be used for archiving and manual upload to the Shopzilla / BizRate Service

Help Desk Software by Kayako fusion