UPDATE: Automated Matchup Options
Offline product matchup services have largly been replaced with automated product matchup services. The automated services are available in a couple different formats. Please see these help pages for details:
Product Matchup & Cleanup through the product editor
Product Matchup through the STN Product Database Hub
In some cases, you may still need STN offline matchup services to assist in data cleanup or migration between platforms. Please see the overview below for details:
Offline Matchup Services:
Whether you are new and need inventory on your site, or it is time for an update to your already populated product listings, we can assist you in getting products pulled into your website with a service we call our Product Match-up Service.
How it works:
- You send us a report from your POS system
- We query our main product database to match-up all the product that we can
- We import those items into your website’s cart system
- We then change the product_sku for each item to use your item number (or equivalent), so you can sync your POS-to-website
Please be aware of potential costs upfront: a POS matchup usually takes 1-2 hours*. The time spent is billed at the STN Members discounted service rates.
The product match-up works best when we get a POS report from you with the following fields. The Report should be in a CSV, Excel, or similar spreadsheet format.
Required Fields:
Item Number (your primary ID – should be unique to each product)
Item Name (Product Name)
UPC Code
Additional Suggested Fields: (these fields will enable us to double-check the matches & match-up more products):
Vendor ID
Vendor Name (Manufacturer’s name)
Vendor Item Number (Item number the Manufacturer uses)
EAN Code
ISBN Code
Optional Fields:
Price (your Product Retail Price)
Category (your Primary Category)
On Hand Qty (Inventory Count)
Please let us know exactly what you would like us to do with the match-up results.
After we match-up your supplied Item Numbers with our Product Database, we can do a number of things. Please let us know which items from the following list you would like us to do with your matchup. The items checked below are the defaults, and we will use these settings unless directed otherwise.
_X_ Send you a report of the matches
_X_ Import the Matching Products into your web cart system
___ Unpublish the imported items
_X_ Update Imported products to use your POS Items Numbers for the “product_sku” field
_X_ Update Imported products with your Costs
___ Update Imported products with your Categories
_X_ Update Imported products with your On Hand Inventory
*A note on time: It’s difficult to give an exact estimate of how much time this process will take. Each store’s data is a bit different, and we have found it to take anywhere from 1 – 5 hrs. We will process your data as fast as we can. Time used above allocated custom hours will be billed at at the STN Members discounted service rates.