updating online inventory levels

1. Congrats! I love PC.
2. Yes, syncing QOH is always hard when you have more than 1 system in place.
3. In the User Manual Pg 110 (or 112) it says that if the product exists in the Database, then it will update it using the sku in the Import file, however if the product doesn't exist in both places then PC will add the product to the Database but it will need to make sure all of the required fields are present to add the products correctly.

Now I am not sure if the products would be ignored or not added to the Database if let's say, you didn't have all of the required information for PC to create a new product from your Import file. (does that make sense, example below.)

If you wanted to test this you could simply create a file to import which only included 2 columns, SKU and QOH and throw in a new test sku for kicks which is not already in PC. Then see if the import failed all together or if it simply ignored adding your "test sku." That would give you your solid answer. :) Let me know what happens.

-Personally, I would add all of your products to your online store, simply because you can just check mark it when you need it to become "active" on the site. Maybe when it's slow in your store or your customers request it online, then you can easily activate your products. But I totally understand the size of that task. I think it is worth it though.-

Hope that helps. If anyone would like to correct me on anything please feel free. :)

P.S. If you don't mind me asking, what POS software are you using? I too would like a POS software which can link up to my PC shopping cart, but am affraid it won't sync up correctly. I would like something like a "live sync." (that would be too easy. Right?:) )

Thanks! I sure hope PC comes out with a POS mod which would allow us to simply enter customer info if we wanted to and add products to the cart in a simple form fashion. :)

I should mention, it provides a bucket load of error messages for all the products that don't sync, but it updated the ones we have online flawlessy.

billh,

I'm so glad it worked. Sorry I didn't reply sooner. I was on Vacation.
I bet there were errors, but if there weren't then those of us who actually want all of the items to be updated wouldn't ever know which items still needed to be fixed. :) But glad you could make it work for your store.