Help Topics

General Help Topics
Site Setup FAQ's Email - Set Up Domains Special Features FrameEZ Troubleshooting
Shopping Cart
Store Configuration Global Configuration Product Management Categories Manufacturers/Brands STN Import Tool Shipping Payment Processors Orders and Sales Shopper Groups Coupons & Discounts Taxes Safety Warnings POS-to-Web Sync
Import/Export Data Components
Contact Us Store Locator Front Page SlideShow Newsletters - Letterman Events Calendar QuickBooks Sync Media Manager SEO Manager Picture Gallery User Manager Banner Manager Language Editor
Wish List Mobile Lightspeed POS Shopify App
Content Management
Product Matchup Service E-mail
Shopping Cart - Product Management
Tuesday, 13 June 2017 09:00

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:

  1. You send us a report from your POS system
  2. We query our main product database to match-up all the product that we can
  3. We import those items into your website's cart system
  4. 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.

 

 

Last Updated on Monday, 15 July 2019 10:04