Importing Product Inventory

[a1webshopping]

I'm trying to come up with an interim fix for my Doba product inventory issues.

So, I already have watch lists that are pulled into ShopSite. I created Doba Data Exports for each of them thinking I could at least upload the inventory for now (and do it daily if necessary manually until I find a permanent fix).

Problem is that it won't write the inventory to the database - kinda.

If the SKU is a number (as in 35467 for example) it will write the quantity from Doba to the Qty in Stock field in ShopSite.

It breaks down when the SKU is anything but a number (as in 3454RFT or 80-4345). For these (which is 99.9% of my SKUs) it writes nothing.

I thought I had a lock on a fix and here I am yet again banging my head against the keyboard.

Any ideas what's going on here and how to fix it?

[Jim]

How are you inputting the quantity, in the backoffice or through an upload of the data in a tab delimited or xml file?

[a1webshopping]

Uploading a tab delimited file.

[a1webshopping]

In the docs I found this (emphasis mine):

-----------------------------------------

SKU - The "Stock Keeping Unit" number for the product

Field Type: numeric
Default Value: Null; there is no default value
Possible Values: Any alphanumeric string

-------------------------------------------

Shouldn't the Field Type be Text? For all I know it is and the docs are wrong but I'm just throwing it out there.

[a1webshopping]

Ok....I got it working finally. Just not used to ShopSite yet I guess.

At least now I can update manually until the Doba issue is fixed. It's still a heck of a lot quicker than my mess with Magento.

Thanks for your help Jim.