Shop Made Simple - adding products

[The_Mark]

I read in another thread, that in order to get "Shop Made Simple" working with added products,
you need to turn of "Pretty URLs".....

Just to get that one solved - is that correct?

[Klassiekerrally]

Does that also mean you can't add products?
That's my problem at the moment... 

[Duketown]

According to me pretty url's are for the front end. Adding products is done in the back end (so no worries about pretty url there I would say) and in the front end.
So which end are you talking about?
Version? Have you tried with debug on to see what happens?

Duketown

[Klassiekerrally]

According to me pretty url's are for the front end. Adding products is done in the back end (so no worries about pretty url there I would say) and in the front end.
So which end are you talking about?
Version? Have you tried with debug on to see what happens?

Duketown

I'm trying to add products via the back end (somehow that sounds strange...).
SMS version 0.1.5
CMSMS version 1.4.1

How do I turn 'debug' on?

[Duketown]

Turning on debug mode is described in:
http://wiki.cmsmadesimple.org/index.php/User_Handbook/Admin_Panel/Troubleshooting

After turning on debug and trying to perform the action that is not working (in this case adding a prodcut) in most cases the problem is shown at the bottom of the page.
Don't forget after debugging to set the debug status back to 'debug = false;'

Duketown

[Klassiekerrally]

OK, I've got an error message. Not sure if it is any help to me, I'm no programmer.

Debug: (0.849308)


(mysql): INSERT INTO cms_module_sms_products(name,
                                                              description,
                                                              price,
                                                              active,
                                                              featured,
                                                              netweight,
                                                              vatcode,
                                                              position)
            VALUES('test','asdfasdf','2345','1',NULL,'1','0','1')
Error (0):

Debug: (0.851)


(mysql): INSERT INTO cms_module_sms_product_category(category_id,
                                                                      product_id)
            VALUES('Test 1',2)
Error (1366): Incorrect integer value: 'Test 1' for column 'category_id' at row 1

[spryoshi]

I'm having the same problem I believe. It wont allow me to set a category for products. When I very first installed it. I put in just a test product and it worked fine. Then when I went to add in an actual product it would not let me set the category. They always show up in root. But there not really in root if you check the category its blank. Im running the same versions. CMSMS 1.4.1 and SMS 0.1.5.

My server log as errors in it like this:
"[Wed Nov 05 12:58:06 2008] [error] [client **.16.143.**] PHP Notice: Undefined index: current_product_images_id in /var/www/vhosts/imimotorsports.com/httpdocs/modules/ShopMadeSimple/action.product_edit.php on line 247, referer: http://imimotorsports.com/admin/modulei ... oduct_id=4"

I have been trying to figure this out for a couple days. Installing and reinstalling SMS but to no avail it might work for just a second after an initial install. But stops working soon after.

Hope this info can help us both.

[spryoshi]

(mysql): INSERT INTO cms_module_sms_product_category(category_id,
                                                                       product_id)
            VALUES('Test 1',2)
Error (1366): Incorrect integer value: 'Test 1' for column 'category_id' at row 1
[/i]

The problem in this it that its putting in "Test 1" instead of the numerical value of the category. I'm going to work with mine some more and see if it is doing the same thing. Cause I just tried a test product again with debug on and it worked fine.

[spryoshi]

Ok I have figured out what is going on. If you view the page source. Sometimes it does not build the page correct.

"rootFun Karts New

"

Catigory Tree: root/kart/prd, root/funkart/new

Instead of placing the numerical value in for "Fun Karts" it placed the words Fun Karts and then with New its fine again. But if you load it up in the "New" sub category it messes up the second option again.

"rootNew
"

Now under the root: (Looks ok)

"root Karts Fun Karts

"

Now if you go into karts: (2nd option messed up again)
"rootKarts PRD (Fire Ball)
"

And if you go into sub category PRD: (Second option PRD is messed up)
"rootPRD (Fire Ball)
"

So it seems to be messing up the second option on them.

Now if you go in to change the category on one you have already listed there all messed up:

"Add Category Fun KartsKartsNewPRD (Fire Ball)
"

Check your sources and see if they are doing the same thing.

[Duketown]

@Klassiekerrally: Thanks, now that I see that, there is more clearity where to look in the code
@spryoshi: Thanks to you, since that type of logging takes quite some time.

I must disappoint you both and quite a number of others. I have no time to solve this within at least 2 weeks.
If someone is out there that has gained knowledge on the coding behind this all and sees a solution, please don't hesitate to mention it. I'll see how I can then prepare a temporary fix or a new release.

Duketown

PS. In relation of the start of the top (pretty url) I was thinking in a very different direction.

[LouiseW]

What a pity! i was just checking out the CMSMS webshop and now it turns out you cannot add products to any other location than the root!

I do hope someone in the CMSMS community can sort this, as this is the only webshop available in CMSMS.

[Klassiekerrally]

What a pity! i was just checking out the CMSMS webshop and now it turns out you cannot add products to any other location than the root!

I noticed that too, and decided to search for an other more 'turn-key' option. One of the possibilities I'm considering is FreeWebShop (freewebshop.org).

[LouiseW]

Ofcourse there are other webshops, however not integrated in CMSMS. If you use freewebshop, you need an extra login just to manage the webshop. I'll give it a try, as it looks nice. Unfortunately the demo is down right now.

I have SMS Version 0.1.5 now in CMSMS 1.4.1. I'll try if an older SMS version doesn't have a problem with adding products. Older versions are found here: http://dev.cmsmadesimple.org/frs/?group_id=190

I tried version 0.1.4 and that works!
The layout is not to my liking, I'll have to modify the styling.
Also navigating through the shop is a problem: there are no navigation buttons to go a page up or down. And after adding items to the cart, that has no button to return to the shop.

Who has already solved this?

My test site is: http://www.loes-online.nl/cmsms/index.php?page=Webshop
Who has a shop up and running?

[Klassiekerrally]

Ofcourse there are other webshops, however not integrated in CMSMS. If you use freewebshop, you need an extra login just to manage the webshop. I'll give it a try, as it looks nice. Unfortunately the demo is down right now.

I can live with the extra login, as the front and backend of SMS aren't very user-friendly IMO.
Also people need to register/login to checkout and pay. I think that should be possible without registration.

I'm in the process of moving my domains to another provider. As soon as that's finished, I'll start to test/use FreeWebShop.

[mehirc]

Hi everybody,

I just stumbled upon the same error and wondered that nobody came up with a solution.

Because I am new to CMSMS I really don't know where to fix this problem, but I found a little workaround I want to share.

You have to modify following files in the ShopMadeSimple-Root:

action.category_add.php

if (isSet($params['submit'])) {
  $params['position'] = intval($params['position']);
...

 
action.product_add.php

if (isset($params['submit'])) {
  $params['position'] = intval($params['position']);
  $params['price'] = floatval($params['price']);
  $params['netweight'] = floatval($params['netweight']);
...

This simply converts all double- and integer-values, coming from the form as strings, into the correct type.

Greetings,

Michael