Manual Product Input thru PHP

[elgrcg]

Hi,

I'm working on v1.3.9.f
I'm having a problem manually inputting a product with Attributes using PHP. When I run the script ant input the products with quantity the products always come up as sold out.
When I use the Stock By Attributes mod, it works.

Any ideas?

Thanks

[kuroi]

Could you clarify what you mean by "manually inputting a product with Attributes using PHP". Do you mean that you've written your own script with PHP and it doesn't work?

[elgrcg]

Could you clarify what you mean by "manually inputting a product with Attributes using PHP". Do you mean that you've written your own script with PHP and it doesn't work?

I have written a script in PHP that is able to enter products with attributes. I have the script take a CSV datafeed file, it has in excess of 20,000 items. I have the data populating the shopping cart, but the quantity is always sold out in the cart, but there is quantity and it is correct when I check the sql database. When I manually enter an item into the cart using the stock by attributes mod included with v3.9.f the quantity shows up properly in the shopping cart.

[Flipside]

products_status = 1

Make sure you are setting the products_status field to one in your script.

[elgrcg]

I just checked the products table, and when there's quantity in the inventory, the products_status is set to 1.

[kobra]

When I run the script ant input the products with quantity the products always come up as sold out.
When I use the Stock By Attributes mod, it works.

I assume that you have stock by attributes installed which adds tables for items with attributes


Is your script addressing these additional tables?

[elgrcg]

Yes, my script does address these tables.
The names of the tables I address are: products_attributes, products_options_types, products_options, products_options_values, products_options_values_to_products_options, and products_with_attributes_stock

[kobra]

I just checked the products table, and when there's quantity in the inventory, the products_status is set to 1.

What about the stock levels in the other tables?
Might cross check all tables altered when you manually enter through the admin versus through your script

A diff tool can locate changes in the sql before and after

[elgrcg]

What tool can locate the changes before and after?
I checked the stock levels in other tables, they're correct.
Let me know about the tool and I'll give it a shot.

Thanks

[kobra]

What tool can locate the changes before and after?

Backup copies of the DB before & after

BeyondCompare
Winmerge
http://www.google.com/search?q=diffe...32b8af52b7e0b8