Why aren't products I've added to my OnSite catalog importing into AdVision eCommerce?

There can be several reasons products in OnSite aren't loading in your AE system.  To troubleshoot, try the following steps:

1. Ensure any products you've created in OnSite have been uploaded to your Lightspeed webstore database (i.e. you've uploaded your latest catalog changes from your POS to the LS webstore database).  If the products have not been uploaded to the LS webstore then AE can not grab them.  If the products have been updated to your LS webstore, move on to step 2 below.
   
   NOTE: as you continue to troubleshoot, make sure to update your LS webstore database with any changes you make to the catalog in LS OnSite.
   
   
2. Are the products that aren't importing assigned as matrix/child items to a parent product that was already imported into AE in the past?  If the parent product already exists in AE, adding child products to that parent in LS will not allow them to be imported.  You need to create the new child products as there own parent items so AE can import them.  Once imported into AE, you can then assign them to the appropriate parent product in both AE and LS.
   
   
3. Do the products you are attempting to import have a product code that matches the inventory ID of a product that already exists in AE?  AE will not import products if the product's code matches the inventory ID of a product already in AE.  Update the product codes in your LS catalog to be unique (not matching any inventory IDs existing in AE) to get the new products to import.
   
   
4. Have you checked to see if the items are archived in your AE catalog?  If the products were previously imported, but have been archived, you'd need to search from them using the archived status, at which point you can make them active again if you so choose.  To find archived items, go to Catalog>>Products, click Search in upper-right of the screen, set Status = Archived, then click Find.
   
   
5. Check the created date for the products in LS.  If items have a created date in the past, AE's import function may miss them if they are just now being uploaded to the LS webstore.  
   
   To fix this, find the oldest created date for the products that aren't importing.  Once you know the oldest created date, login to your AE admin and go to Settings>>Inventory Gateways.  Click on the gateway your importing from.  In the field labeled Last Load Date, reset the date to the day before your oldest created date.  For example, if the oldest created date you found is 2014-12-07, you would change the Last Load Date to 2014-12-06.  Once you've changed the date, click Save Changes.  On reload, click Get New Products.  AE will now attempt to grab any products with a created date after the Last Load Date you set.
   
   NOTE: when the form first loads, if you find the value in Last Load Date is older than 24 hours in the past, please alert AE support as this may indicate the automated import is not functioning.  The automated import should be running at least once every 24 hours.

If you've run through these troubleshooting tips and your products are still not importing, please open a ticket with AdVision eCommerce support.