Integration of KonaKart into an Open Source ERP webapplication

[magsam]

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

[julie]

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.

Great minds think alike 

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 assume you are referring to our store-front application? If so, we've introduced a naming convention. Take a look at ProductDetailsBody.jsp . For each image we have image_1.jpg, image_1_big.jpg ............ image_4.jpg, image_4_big.jpg. This was purely an application related decision because we found a nice image viewer that requires 4 small and 4 large images. Depending on the image viewer you choose, you can invent your own naming convention or use the names directly from the four image fields that a product has.

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.

I think that the table you are missing is the products_quantity table. In order to see how we populate it, try editing a product that has attributes and click on the quantities tab so that you can enter multiple SKUs and quantities for each.

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.

Please write to enquiries AT konakart DOT com . 

Regards from Bavaria

Prost !

[magsam]

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

[julie]

This is the way it works:

Lets say that you have a shirt which can be small, medium and large and can come in 2 colors, red and green. In this case you will have 6 rows because you have 6 combinations, each of which can have an SKU.

[magsam]

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

[julie]

Guten Tag Peter,

Rather than having a price per SKU, it works by associating a delta price for each option and when you pick an SKU the price will be determined depending on the options within the SKU. If you look at our demo store http://www.konakart.com/konakart/SelectProd.do?prodId=1 you'll see that each of the options can change the price. Obviously on the UI you can display the price as you wish (i.e. as a delta price as in the demo or as a final price).

I don't see a problem with your example. In KonaKart you would define a set of product options for height, depth and for wood-type. If you have 5 wood types and 7 heights and 3 depths, then "Quantities Tab" for that product you should see 105 lines where you can insert 105 SKUs and 105  quantities. If the price change for moving from one height to another height, changes depending on the wood type, then you need to define a different set of height options for each wood type.

In order to get the SKU in the order you don't have to do anything. If you've defined an SKU it should appear in the products_sku attribute of the orders_products table, where the order products are individual products within an order.

[magsam]

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

[greg]

Does this help you?:  http://www.konakart.com/forum/index.php/topic,1198.msg4846.html#msg4846

[magsam]

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

[greg]

Hi Peter,

I don't understand.  Can you reproduce on our demo site and let us know how: 
http://www.konakart.com/konakart/Welcome.do

What is the URL on the product that is wrong?

Which JSP are you talking about?  Have you changed it?

Greg

[magsam]

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

[greg]

Hi Peter,

So...  you downloaded and installed KonaKart and presumably everything worked - including all the product images.

Then you added some products and product images and then it didn't work any more?


You say the "first image" doesn't work.   Can you please clarify what you mean?   Maybe you could attach a screenshot?

What is the "general view" that you mention below?  (a screenshot might be helpful)

What is the Full exception (full stack trace) that you are seeing.

Greg

[magsam]

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.