BigCommerce Product Data Feeds
- Where to find your BigCommerce Store Hash
The BigCommerce Store Hash is a unique identifier for your store comprised of a short sequence of lower-case letters and number. It can be found in the URLs assigned to your store by BigCommerce. Read on for two different ways to locate your store hash.
Method 1: BigCommerce Store Hash from Permanent Address (or Temp URL)
- Login to your BigCommerce Account Dashboard as the store owner
- Click on your Store Name
- Scroll down to the Details section
- The Permanent Address will be displayed as:
https://store-abcde12345.mybigcommerce.com
abcde12345 is the store hash
Method 2: BigCommerce Store Hash from API Path
- Log into your BigCommerce Store Control Panel
- Go to Advanced Settings > API Accounts
- Click the Create API Account button
- The API Path will be displayed as:
https://api.bigcommerce.com/ stores/abcde12345/v3/
abcde12345 is the store hash
References
- Bing Shopping Feed BigCommerce
Option 1: Express Setup Request
We recommend that you have us set up and optimize the data feed for you with our Express Setup and Optimization Service. There is a one-time fee associated with this service.
To purchase this service, paste the password you created, API Token, API Path, and any special instructions into the 'Additional Comments' field of our Express Setup Request Form, and click Submit Request.
Option 2: Do-it-yourself Setup
Use our Bing Shopping Data Feed Setup Guide to complete the setup of your Bigcommerce Bing Shopping Feed.
- Advantages of our feed vs. the one provided by BigCommerce or Shopify
- We have over 15 years experience in data feeds, so we have the expertise to get your products listed correctly and in an optimal way.
- We provide free phone/email support for your feeds, which is especially useful when there are feed errors and when the feed specifications change.
- Standard feeds include 'Smart' fields, which use our proprietary logic to improve data quality for product_type, GTIN, size, color, etc.
- With our free Google Shopping Monitoring Service, we email you whenever there is a problem with your listings.
- We specialize in very large stores, complex stores, and other cases where the built-in or free software does not suffice.
- You can filter out items with errors to prevent your feed from being disapproved by Google.
- We offer Google Shopping Categorization Service for an additional fee.
- We support all the major shopping engines - including Bing Shopping, Facebook Product Ads, and Pinterest Product Ads.
- We support international feeds with multi-language support and automatic currency conversion.
- Our feeds are pre-configured with URL tracking codes for Google Analytics.
- All feeds have a fixed, file download URL. Feeds are in CSV format, easily viewable in Excel/OpenOffice Calc.
- Our system gives you the ability to customize the feed.
- You can use our Google Validation Report to quickly view and identify item errors/warnings.
- We keep track of the results of each feed submission.
- How to Add Custom Fields to a BigCommerce Store
To add custom attributes to a BigCommerce product catalog, you have the four options listed below:
1. BigCommerce Custom Fields
The preferred way to add BigCommerce Custom Fields is to use the built-in Custom Fields feature. There is an easy way to hide BigCommerce Custom Fields from appearing on your product pages.
We can map your Custom Fields to any attribute of the feed. This feature is turned off by default (for performance reasons). If you want the Custom Fields available in your feed, please contact us and we can turn that feature on for you.
2. BigCommerce Meta-Fields
Meta-fields are an ideal way to store extra data in your catalog. You can store data at the product or variant level, or both. Our system can import this data and incorporate it into your feed.
You can search for a Metafield Manager App in the app store to add, view, edit, import, or export BigCommerce metafields. Besides using an app, the only other way to manage these is via the BigCommerce API.
3. Use an Unused Field
You can also enter data into built-in product attributes that you are not likely to use for anything else. Here are some unused field suggestions:
- Other Details
- Bin Picking Number, Warranty Information, Search Keywords
- Accounting Settings
- Asset Account Code, Income Account Code, Expense/COS Account Code
- Peachtree Fields
- General Ledger Account
- Google Shopping
- Color, Size, Material, Pattern
We can map any of the above fields to any attribute in your feed. For example:
Bigcommerce => Google Feed Attribute Color => custom_label_0 Material => custom_label_1 Pattern => custom_label_2
4. Google Sheets
You can set up a Google Sheet (public read-only, unlisted), and add product ID and custom attributes there. With a Custom feed, we can program your feed to incorporate data from the Google Sheet. Please contact us for more information.
5. Private Database
We can also provide you with a private database, where you can directly enter the data. The advantage of this is that the product IDs can be automatically maintained. Please contact us for more information.
- How to hide Custom Fields from BigCommerce product pages
BigCommerce Custom Fields provide an easy way to store arbitrary product data in your product catalog. The problem is that by default, each custom field you add will also display on the product page for the item.
To prevent Custom Fields from appearing on product pages in BigCommerce, add the CSS below to your theme:
// Hide first custom field dl.productView-info dt:nth-child(1) { display: none; visibility: hidden; } dl.productView-info dd:nth-child(2) { display: none; visibility: hidden; } // Hide second custom field dl.productView-info dt:nth-child(3) { display: none; visibility: hidden; } dl.productView-info dd:nth-child(4) { display: none; visibility: hidden; } // Repeat for additional custom fields ...
The CSS code above will remove the Custom Fields from your product page.
Using Custom Fields is the preferred way to store additional product details, as opposed to using unused fields.
- Customize the BigCommerce Product Export for Performance
Below is a list of fields you can uncheck to improve the performance of the BigCommerce product export. To access this list, click the Products tab when editing the export template in your BigCommerce store control panel.
The fields listed below are rarely, if ever, used for generating data feeds for the shopping channels. However, to maintain maximum flexibility for the future, you should only uncheck these if you are having problems with your feed.
Bin Picking Number Brand + Name Option Set (keep for variant feeds) Option Set Align Cost Price Calculated Price Retail Price Fixed Shipping Price Free Shipping Warranty Product Not Visible Product Inventoried Date Added Date Modified Low Stock Level Product Files Product Images > Product Image ID Product Images > Product Image File Product Images > Product Image Path Product Images > Product Image Description Product Images > Product Image Index (Note: For Product Images, only URL and Is Thumbnail are needed) MYOB Asset Acct MYOB Income Acct MYOB Expense Acct Event Date Required Event Date Name Event Date Is Limited Event Date Start Date Event Date End Date Sort Order Product Tax Class Stop Processing Rules Redirect Old URL Avalara Product Tax Code Product Custom Fields (keep if enabled for your feed) Product Availability Minimum Purchase Quantity Maximum Purchase Quantity Show Product Condition Shipping Groups Origin Locations Dimensional Rules GPS Custom Item
Unchecking the above fields may greatly increase the speed of the export, and reduce the file size.
- BigCommerce Store API Account Setup (OAuth Token)
If you have Standard feeds, simply Install our App instead of using the instructions below.
Otherwise, if you have a Custom feed that requires additional scopes, you can use these instructions to create an alternate API Token.
- Log into your BigCommerce Store Control Panel
- Go to Settings > API > Store-level API Accounts (Only Store Owners can see this option.)
- Click the "+ Create API Account" button.
- For Token Type, select V2/V3 API Token
- For Name, enter atensoftware
- Under OAuth Scopes, select the following:
- Information & Settings - Readonly
- Products - Readonly (or Modify for Custom Product/Inventory update feeds)
- Sites & Routes- Readonly
- Store Inventory- Readonly
- Click Save
- Download the
.txt
file to your computer - Log in to your Aten Software account, or if you have no account yet, Register an account.
- Send the contents of the
.txt
file using the Secure Login and Password page.
References
- BigCommerce Support - Store API Accounts
- BigCommerce API Docs - Obtaining OAuth Tokens - Authenticating with OAuth
- Error Installing BigCommerce App: Detected Browser Preventing Cross-site Cookies
When installing our Product Data Feed BigCommerce App, you may encounter the following error message:
We have detected that you are using a browser which is preventing cross-site (3rd party) tracking cookies. In order to install this application, you must temporarily enable cross-site cookies to allow information to be shared with the developer of the application. How to disable 3rd party cookies.
This an issue specific to the BigCommerce App Atore, and is not something that we can resolve on our end.
To fix the error, any of the following recommendations might work:
- Enable 3rd party (cross-site) tracking cookies in the browser settings
- Try 'incognito' or 'private' browsing mode
- Use an entirely different web browser
- Temporarily disable privacy-related web browser extensions
- Temporarily disable anti-virus software
If all else fails, the last option is to manually create the credentials using these instructions: BigCommerce Store API Account Setup (OAuth Token). However, this should be avoided since it is a a much more manual procedure.
- What data do you import from BigCommerce?
Currently, our system imports all products (along with their variations) returned by the catalog/products API endpoint.
All feed templates are pre-configured with filters to remove hidden and disabled products. Coming soon, hidden and/or disabled products will NOT be imported by our system at all.
Availability (in stock/out of stock) is computed automatically and correctly.
All product data is imported by default, including variants, bulk pricing rules, images, primary image, and custom fields.
Our system is capable of importing a wide variety of additional product-related data for special cases, such as:
- Product-level meta-fields
- Variant-level meta-fields
- Merged value of product-level and variant-level meta-fields
- All brand information, including brand-level meta-fields
- Product reviews
- Price lists
- Channel assignments
- Inventory at locations
- Store currencies
- Store information