My Checkout Without Account Mod

[sagivle1]

What version of Zen are you using?

i am using zen cart v 1.3.7

[Dexter]

Warning: It look like the SQL file that comes with this mod somehow breaks the required attributes functions!! Now customers can checkout without filling the required fields....(php 5.x/php 4.x - MySQL 4/5) It may not do this for you...

Anyway here is a Fix that I found else where on this forum and look like its working again now, just in case this does happened to you:

Please remember to backup your database before make any changes and best to use this code with phpadmin and not the Zen cart admin

INSERT INTO `configuration` VALUES ('', 'Product option type Select', 'PRODUCTS_OPTIONS_TYPE_SELECT', '0', 'The number representing the Select type of product option.', 0, NULL, '2007-03-19 17:57:39', '2007-03-19 17:57:39', NULL, NULL);
INSERT INTO `configuration` VALUES ('', 'Upload prefix', 'UPLOAD_PREFIX', 'upload_', 'Prefix used to differentiate between upload options and other options', 0, NULL, '2007-03-19 17:57:39', '2007-03-19 17:57:39', NULL, NULL);
INSERT INTO `configuration` VALUES ('', 'Text prefix', 'TEXT_PREFIX', 'txt_', 'Prefix used to differentiate between text option values and other option values', 0, NULL, '2007-03-19 17:57:39', '2007-03-19 17:57:39', NULL, NULL);
INSERT INTO `configuration` VALUES ('', 'Image Handler Version', 'IH_VERSION', '2.0', 'This is used by image handler to check if the database is up to date with uploaded image handler files.', 0, 100, NULL, '2007-06-06 16:47:03', NULL, 'zen_cfg_textarea_small(');

[birdoasis]

Does the fix...break anything else?

I usually don't bother with atributes, but I was thinking about doing that on birdersbinocualrs.com and wanted to be sure that the fix didn't go where fixes shouldn't go.

JP

[Dexter]

first test to see of your required attributes function is working :)

if its not the fix just reset some settings in your database it does not break anything else :)

[KTNaturals]

Mine broke after installing the google sitemap mod. For some, it was imagehandler2, which I don't have installed. I'm not sure if COWOA did or not.

[Dexter]

What ever addon broke it this sql will fix it And the best part is that the addon will keep working normal also

[craftzombie]

Warning: It look like the SQL file that comes with this mod somehow breaks the required attributes functions!! Now customers can checkout without filling the required fields....(php 5.x/php 4.x - MySQL 4/5) It may not do this for you...

Anyway here is a Fix that I found else where on this forum and look like its working again now, just in case this does happened to you:

Please remember to backup your database before make any changes and best to use this code with phpadmin and not the Zen cart admin

INSERT INTO `configuration` VALUES ('', 'Product option type Select', 'PRODUCTS_OPTIONS_TYPE_SELECT', '0', 'The number representing the Select type of product option.', 0, NULL, '2007-03-19 17:57:39', '2007-03-19 17:57:39', NULL, NULL);
INSERT INTO `configuration` VALUES ('', 'Upload prefix', 'UPLOAD_PREFIX', 'upload_', 'Prefix used to differentiate between upload options and other options', 0, NULL, '2007-03-19 17:57:39', '2007-03-19 17:57:39', NULL, NULL);
INSERT INTO `configuration` VALUES ('', 'Text prefix', 'TEXT_PREFIX', 'txt_', 'Prefix used to differentiate between text option values and other option values', 0, NULL, '2007-03-19 17:57:39', '2007-03-19 17:57:39', NULL, NULL);
INSERT INTO `configuration` VALUES ('', 'Image Handler Version', 'IH_VERSION', '2.0', 'This is used by image handler to check if the database is up to date with uploaded image handler files.', 0, 100, NULL, '2007-06-06 16:47:03', NULL, 'zen_cfg_textarea_small(');

And just to clarify... I made NO changes to the SQL or any other code that originally came with this mod. I simply added the given code to the new 1.3.8 files.

[cannontrodder]

The sql file that comes with this mod does 3 things:

It adds a tinyint called COWOA_account (1) and COWOA_order (2) to the customers and orders tables. I haven't looked at the php code but I presume this is used as a flag to indicate if an account/order is a COWOA one. It also adds a query to the query_builder table to allow you to send emails to permanent account holders only.

Remember, although this mod says you can buy without an account, it's not really true. It creates an account that you cannot log in to and makes sure you do not receive any correspondence from the site. The modified code uses the above flags to differentiate between details it has for account holders and people who checked out without formally creating an account.

So, in summary, if the sql was broken, it wasn't this mod that did it.

[Dexter]

Sorry I was pretty sure it was this mod, like its the only one I did install and this happend to me in both 1.3.7 and 1.3.8

[elfino45]

I love this mod.

thanks for it.

Here's my situation:

I recently switched over to this mod because the login/register feature was kind of annoying me. I sell t-shirts online and in the t-shirt biz, there is a lot of impulse buying. so the zen cart account system was causing too much shopping cart abandonment.

but with this mod i have installed, existing customers cannot order because the email address is already in use. is there a way to change every email address in one fell swoop? Maybe I could add a "." in front of each email so that I can retain the customer information while allowing these people to order with their existing email address. or i'm also open to suggestions.

question #2) i just installed the order status add-on that allows a customer to check the status of an order with only the email address and the order number. the read me states that it adds "order_status". forgive my stupidity, but what is the link to that? e.g. www.xxxxxxxx.com/store/ ???

help me fill in the blanks. thanks. :)