qtpro and product options

[wrequine]

I am not a coder, so I have no idea if this is really possible, but I would like to hear what people think about this idea.

 

We all know a common problem with oscommerce is how to handle inventory of products with different attributes. QTPro will track inventory of the different product options, but there is still the all elusive separate sku for each option. What about this?:

 

In catalog/admin/includes/stock.php we can add stock for each individual product option. Would it be possible to include an extra field here? I am thinking it would be between the attributes and the quantity fields. In this extra field we can manually enter an sku to match that particular set of product attributes. It's a simple, manual solution, but if it would work, at least it's a solution.

 

Of course, this would also need to be integrated with AAM so the same field would be available on the product info page. And, if possible, stock.php would need to become editable to fill in sku's for already existing product attributes.

 

Again, I am not a coder, but in my simple mind this deserves a go. What I want to know is, is this actually possible? And would it be as simple as it sounds? If it is possible, is there anyone out there willing to give this a shot, then share with the rest of us?

[♥Monika in Germany]

I have done a custom solution very similar to what you outlined, just keep in mind that similar to products_quantity, the sku would also need to be added to the products table and filled only for items that do not come in different options and so are never being added to the stock table ...

[wrequine]

I have done a custom solution very similar to what you outlined, just keep in mind that similar to products_quantity, the sku would also need to be added to the products table and filled only for items that do not come in different options and so are never being added to the stock table ...

 

Would that simply be handled by using the default Product ID field in the product info page, or is there more to it than that?

[♥Monika in Germany]

I'm sorry Angela, but I do not understand your question.

 

products_id used as an sku?

[spoofy]

Hello Monika,

 

I have contacted you via pm and your website regarding the custom solution you talked about.

 

Please let me know.

 

Thanks