Manual Product Input thru PHP

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
:frusty:

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?

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?

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.

products_status = 1

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

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

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?

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

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

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

What tool can locate the changes before and after?
Backup copies of the DB before & after

BeyondCompare
Winmerge
http://www.google.com/search?q=difference+applications&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-US:official&client=firefox-a#sclient=psy&hl=en&client=firefox-a&hs=Coj&rls=org.mozilla%3Aen-US%3Aofficial&q=file+compare+utility&aq=f&aqi=g4g-o1&aql=&oq=&gs_rfai=&pbx=1&fp=6f32b8af52b7e0b8

I've been doing exactly that.
Going to try uploading just one item with attributes, of the 20,000 datafeed, and manually input one item thru the stock by attributes mod, and do a comparison of the DB tables to see if I can spot anything.

As it is functional through the admin it must be something you are missing in your script

Exactly.
It's about 300+ lines.
Is there a way I can privately share the script with you?

Exactly.
It's about 300+ lines.
Is there a way I can privately share the script with you?
Only if you intend on contributing & supporting it

To put it another way ... debugging 300+ lines of code for your personal use would be way beyond the scope of a user-to-user support forum.

However, if your intention is to package and contribute that code for wider use, there are people who may be prepared to help as part of their contribution to the wider community.