Topics

Hello Community,

I need your help concerning the drop down list for the products with several options. I store the product with all its  options and attributes in the products_attributes.

.For example I have 3 sizes and 3 colors' I store 6 sentences. Now I build the the table products_quantities . There I store the possible combination in the field products_options  together with the quantity and the products_sku. There I store only 3 sentences because only this combination of the attributes is possible (not each size has all colors). I have no bundled products

In the Shop I can chosse 9 options (all values from products_attributes). This is of course wrong.

My question:  how is it possible to show in the drop downlists only the combinations (dependencies)  which is stored in products_quantities?

Thank you for your help.

Peter

Hello Community,

I have developed an Open Source application with Netbeans (java and web based) for retailers. The next step is to integrate a web shop. I think the best is to use konakart. Now I am learning how konakart works. I have to synchronize my ERP solution osRetail www.ka-und-we.de  (you can compare it with the SAP retail solution) with the web shop. I have some questions which the konakart specialists can answer. osRetail makes the updates of the products direct into the konakart database. The functions already works fine. It was hard work to develop this function.

I am missing a table which connects the products_image with the other images when you click on the first image. There is no documentation how to do this.

I import the orders into osRetail for shipping. The logistics need the number of the SKU and not a list of the attributes. A product (Parent) can have a lot of SKU's with a lot of different values and the values have different attributes. Each specification has an own number in the stock and an own price.  I am missing a table which connects the product with the SKU. The product is the brace for the real SKU. Seldom a product is one SKU. One product many SKU's but one sentence for a SKU below the values with there attributes.

Do you have a special documentations for your database?

I am sure there is a solution for my problem.

My partner Ancud www.ancud.de and I want to be solution providers. What are the steps to be this? Of course do we need for tests the enterprise edition. 

Regards from Bavaria

Peter Magsam