Messages

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

Hi Greg,

when I tell you about the "first image" I mean this image   -  image.jpg    -   look at your example -    without any number. . When you click on this image - in your examples - you see the details of the product. But when I click on my own image which is stored correct and correct conected with my products I get a null pointer exeption. 

Hi Greg,

I have installed  you demo webshop on my computer. I am just integrating konakart into my ERP system osRetail. I did not change anything in konakart . I store direct with ftp the images and I store all informations which are necessary direct  in the product tables. I do not use your webservice. I works besides the first image .

Peter

Hi Greg,

the syntax of the stored images is like konakart wants it. It is a problem with the hyperlink on the first image.jpg 

Peter

Hello Julie,

I need your help again concerning the images of the products. I have written a program to import them. I works fine and I the syntax is as required . I see the images in the webshop. But when I click on the first image  - stored in products_image -   which is shown in the general view I get - The details of the malfunction are :
Exception Name = java.lang.NullPointerException - . When I buy the product I see all other photos but not the first one. There must be a hyperlink on the first photo which is stored under products_image.

Please tell me the "secret" about this hyperlink. 

Thank you

Regards

Peter

Guten Tag Julie ,

I have followed your advice. I am still missing the number of the sku in the order. Please tell me how I get the number of the sku in the order?

Is it possible to store a price together with the sku. Often we have different prices for the sku's.  Our customers want one price (no + or  - by the attributes) for a sku.

A product with one sku works fine but we have customers who have a product with 40 sku's.  Look at this web shop. This is typical.

http://memo.de/Bueromoebel/Regale_und_Schraenke/Das_TREND-Regalsystem/Grundregale_43,7_cm.memo?groupId=7559&page=group.jsp

What do you advice to handle such products?


Regards

Peter

Hi Julie,

thank you for your answer. The first "problem" is solved. When a product has only one attribute your suggestions works, but what about a product has 6 attributes? The I get 6 table rows one row for each attribute. The 6 rows represent one SKU. I a sure you know a solution. So I need a table between product and product_quantity.

Regards

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