Guest Posted August 6, 2005 Share Posted August 6, 2005 I've no idea why or how, on playing around entering the mysql statements above individually everything now seems to work. :huh: Quote Link to comment Share on other sites More sharing options...
baesic2 Posted August 6, 2005 Share Posted August 6, 2005 Id would like to know where in the each to add the new lines of code for installation. I noticed in the readme.txt file it says to add for example OPEN AND MAKE CHANGES IN THIS FILE: /catalog/includes/application_top.php //Begin Checkout Without Account Modifications define('FILENAME_PWA_PWA_LOGIN', 'login_pwa.php'); //BMC new as of v0.57 define('FILENAME_PWA_ACC_LOGIN', 'login_acc.php'); //BMC new as of v0.57 define('FILENAME_CHECKOUT', 'Order_Info.php'); //End Checkout Without Account Modifications But where do we put these in that file do we just add it anywhere in the file just asking cause I am looking for this function and I do not fully understand how to install it properly. Thanks for the update though I am looking to get this function working soon. Quote Thank You In Advance, For Your Assistance From A Newbie Point Of View... Happiness is Getting OSC Operating to it's fullest potential and with the help of Contributors and Forum Moderators, we can all do it. Support the cause. Donate to osCommerce. baesic2 Link to comment Share on other sites More sharing options...
bongo Posted August 8, 2005 Share Posted August 8, 2005 Hi, Thanks for this good contribution. I have one problem now. I cant figure out how to add more fields. I have tried to copy one of the other that already are there, has also inserted an new field in the database. Is there somebody that can help we with this? Regards Thomas Quote Link to comment Share on other sites More sharing options...
Guest Posted August 9, 2005 Share Posted August 9, 2005 OK, I just installed this contrib and am confused... during the purchase process, the customer clicks on CHECKOUT (without account) and it says no personal information is stored... however, when I go into my ADMIN pages, the personal information was stored. Is this the way it is supposed to work. I understand some of it needs to be saved for processing of the order, but is it indefinately held? For example, if the same person comes back to the store to purchase again and enters his e-mail address, is it going to say that there is already an account under the e-mail? I know it shouldn't be working like that, but looks like it is working that way... help! Jim Quote Link to comment Share on other sites More sharing options...
Guest Posted August 9, 2005 Share Posted August 9, 2005 I am also noticing that the program is remembering who I am each time I open the website. I am using my test account, but have to delete the cookies each time to test. Is there a way to fix this also? Jim Quote Link to comment Share on other sites More sharing options...
bongo Posted August 9, 2005 Share Posted August 9, 2005 OK, I just installed this contrib and am confused... during the purchase process, the customer clicks on CHECKOUT (without account) and it says no personal information is stored... however, when I go into my ADMIN pages, the personal information was stored. Is this the way it is supposed to work. I understand some of it needs to be saved for processing of the order, but is it indefinately held? For example, if the same person comes back to the store to purchase again and enters his e-mail address, is it going to say that there is already an account under the e-mail? I know it shouldn't be working like that, but looks like it is working that way... help! Jim <{POST_SNAPBACK}> Dear Jim, Is it saved also in the customer tables? or just in order? Because it's going to first save it in customer sql tabell and the deletes it from there. And if an customer uses the same email address several times its fine. He dont get any errors because the only place it will be stored is in orders tabell and that tabell is the tabell that checks if the customer is registrerd before. Sorry about my bad english. Hope you understand me enough sow im helpful :D Regards Thomas Quote Link to comment Share on other sites More sharing options...
Guest Posted August 9, 2005 Share Posted August 9, 2005 If I go to the customers page in ADMIN, the person who used Purchase Without Account is listed. Now using my test account, I let it go as far as bringing up the paypal screen, but never completing the transaction. It places the order in the PENDING stage with the PayPal IPN. When does it delete the customer info? Quote Link to comment Share on other sites More sharing options...
boxtel Posted August 10, 2005 Share Posted August 10, 2005 OK, I just installed this contrib and am confused... during the purchase process, the customer clicks on CHECKOUT (without account) and it says no personal information is stored... however, when I go into my ADMIN pages, the personal information was stored. Is this the way it is supposed to work. I understand some of it needs to be saved for processing of the order, but is it indefinately held? For example, if the same person comes back to the store to purchase again and enters his e-mail address, is it going to say that there is already an account under the e-mail? I know it shouldn't be working like that, but looks like it is working that way... help! Jim <{POST_SNAPBACK}> the customer info is stored as normal to minimize the changes needed for this. However, it is deleted at checkout success when the order is completed and only the order information is retained. but, if the customer does not get to checkout success, the data remains and is subsequently deleted when the same customer enters that email address again. so yes, you can have a lot of PWA customers in your customers table but those entries will be deleted when they complete checkout or come back. Quote Treasurer MFC Link to comment Share on other sites More sharing options...
AllThingsTrendy Posted August 11, 2005 Share Posted August 11, 2005 I really need this contribution. Thanks so much for posting. Before proceeding, a few questions: I have already installed the Credit Class & Gift Voucher contrib and quite a few others. Is this compatible withe CCGV? I've looked throught the files in this contrib. I don't find any tags in some of the files to indicate what was changed specifically for the contrib. I am getting better at this. But, still a newbie. How do you compare the files for what is needed in this contrib to what I have in my modified files? The following files are modified by both this and the credit voucher contrib; but with no indication of the changes.... /catalog/checkout_process.php (modified in Credit Voucher contrib) /catalog/checkout_success.php (modified in Credit Voucher contrib) /catalog/create_account.php (modified in Credit Voucher contrib) /catalog/includes/header.php (modified by other contribs) /catalog/admin/orders.php (modified by other contribs) ANY help would be appreicated! Quote Anthony David AllThingsTrendy.com Link to comment Share on other sites More sharing options...
luca75 Posted August 12, 2005 Share Posted August 12, 2005 Hi, I have installed this great contribution, is all ok, but when arrive the e-mail at the customer there is price = 0.00 near the item buyed this is the only problem sorry if there is the solution in this post but is very big... Quote Link to comment Share on other sites More sharing options...
bongo Posted August 13, 2005 Share Posted August 13, 2005 Id would like to know where in the each to add the new lines of code for installation. I noticed in the readme.txt file it says to add for example OPEN AND MAKE CHANGES IN THIS FILE: /catalog/includes/application_top.php //Begin Checkout Without Account Modifications define('FILENAME_PWA_PWA_LOGIN', 'login_pwa.php'); //BMC new as of v0.57 define('FILENAME_PWA_ACC_LOGIN', 'login_acc.php'); //BMC new as of v0.57 define('FILENAME_CHECKOUT', 'Order_Info.php'); //End Checkout Without Account Modifications But where do we put these in that file do we just add it anywhere in the file just asking cause I am looking for this function and I do not fully understand how to install it properly. Thanks for the update though I am looking to get this function working soon. <{POST_SNAPBACK}> Isnt there somebody that can help me inserting more fields in the checkout? Regards Thomas Quote Link to comment Share on other sites More sharing options...
djmonkey1 Posted August 14, 2005 Share Posted August 14, 2005 Id would like to know where in the each to add the new lines of code for installation. I noticed in the readme.txt file it says to add for example OPEN AND MAKE CHANGES IN THIS FILE: /catalog/includes/application_top.php //Begin Checkout Without Account Modifications define('FILENAME_PWA_PWA_LOGIN', 'login_pwa.php'); //BMC new as of v0.57 define('FILENAME_PWA_ACC_LOGIN', 'login_acc.php'); //BMC new as of v0.57 define('FILENAME_CHECKOUT', 'Order_Info.php'); //End Checkout Without Account Modifications But where do we put these in that file do we just add it anywhere in the file just asking cause I am looking for this function and I do not fully understand how to install it properly. Thanks for the update though I am looking to get this function working soon. <{POST_SNAPBACK}> As far as I can tell there are no modifications to /catalog/includes/application_top.php. Are you using version 0.82? If so, try this: ********************************** catalog/includes/filenames.php ********************************** add at end before ?> // PWA define('FILENAME_PWA_PWA_LOGIN', 'login_pwa.php'); define('FILENAME_PWA_ACC_LOGIN', 'login_acc.php'); define('FILENAME_CHECKOUT', 'Order_Info.php'); define('FILENAME_ORDER_INFO', 'Order_Info.php'); define('FILENAME_ORDER_INFO_PROCESS', 'Order_Info_Process.php'); // end PWA There is a great contribution from Mace that has just install instructions for sites that have other contributions- should work great for anyone. I haven't tested it yet though so we'll see. Quote Do, or do not. There is no try. Order Editor 5.0.6 "Ultra Violet" is now available! For support or to post comments, suggestions, etc, please visit the Order Editor support thread. Link to comment Share on other sites More sharing options...
djmonkey1 Posted August 14, 2005 Share Posted August 14, 2005 Hi, Thanks for this good contribution. I have one problem now. I cant figure out how to add more fields. I have tried to copy one of the other that already are there, has also inserted an new field in the database. Is there somebody that can help we with this? Regards Thomas <{POST_SNAPBACK}> Thomas- I have the same problem. I don't know how to modify my database. I'm muddling through with php MyAdmin 2.5.6. How about you? Quote Do, or do not. There is no try. Order Editor 5.0.6 "Ultra Violet" is now available! For support or to post comments, suggestions, etc, please visit the Order Editor support thread. Link to comment Share on other sites More sharing options...
djmonkey1 Posted August 14, 2005 Share Posted August 14, 2005 Thomas- Modifying the database turned out to be really easy. Each line in the instructions such as ALTER TABLE customers ADD purchased_without_account TINYINT(1) UNSIGNED DEFAULT '0' NOT NULL AFTER customers_id; is a SQL command you have to run on your database. In phpMyAdmin, when you login there is a link that says "Query Window" at the bottom of the page. Click on that, and a window will pop up. Inside the window there is a box, and inside mine there is the default message of SELECT * FROM WHERE 1 I replaced that with one of the SQL commands and hit "Go". The database was then altered. Hopefully this helps you. Please let me know! Cheers Stew Quote Do, or do not. There is no try. Order Editor 5.0.6 "Ultra Violet" is now available! For support or to post comments, suggestions, etc, please visit the Order Editor support thread. Link to comment Share on other sites More sharing options...
bongo Posted August 15, 2005 Share Posted August 15, 2005 Thomas- Modifying the database turned out to be really easy. Each line in the instructions such as ALTER TABLE customers ADD purchased_without_account TINYINT(1) UNSIGNED DEFAULT '0' NOT NULL AFTER customers_id; is a SQL command you have to run on your database. In phpMyAdmin, when you login there is a link that says "Query Window" at the bottom of the page. Click on that, and a window will pop up. Inside the window there is a box, and inside mine there is the default message of SELECT * FROM ?WHERE 1 I replaced that with one of the SQL commands and hit "Go". The database was then altered. Hopefully this helps you. Please let me know! Cheers Stew <{POST_SNAPBACK}> Stew, Thanks for the reply, This i have figured out. But its the php files that i dont figure out. Do you now how insert the fields in the php files also? Thanks for your help -Thomas- Quote Link to comment Share on other sites More sharing options...
AllThingsTrendy Posted August 15, 2005 Share Posted August 15, 2005 bump... :'( I really need this contribution. Thanks so much for posting. Before proceeding, a few questions: I have already installed the Credit Class & Gift Voucher contrib and quite a few others. Is this compatible withe CCGV? I've looked throught the files in this contrib. I don't find any tags in some of the files to indicate what was changed specifically for the contrib. I am getting better at this. But, still a newbie. How do you compare the files for what is needed in this contrib to what I have in my modified files? The following files are modified by both this and the credit voucher contrib; but with no indication of the changes.... /catalog/checkout_process.php (modified in Credit Voucher contrib) /catalog/checkout_success.php (modified in Credit Voucher contrib) /catalog/create_account.php (modified in Credit Voucher contrib) /catalog/includes/header.php (modified by other contribs) /catalog/admin/orders.php (modified by other contribs) ANY help would be appreicated! <{POST_SNAPBACK}> Quote Anthony David AllThingsTrendy.com Link to comment Share on other sites More sharing options...
djmonkey1 Posted August 16, 2005 Share Posted August 16, 2005 Stew, Thanks for the reply, This i have figured out. But its the php files that i dont figure out. Do you now how insert the fields in the php files also? Thanks for your help -Thomas- <{POST_SNAPBACK}> Which fields are you trying to change? Quote Do, or do not. There is no try. Order Editor 5.0.6 "Ultra Violet" is now available! For support or to post comments, suggestions, etc, please visit the Order Editor support thread. Link to comment Share on other sites More sharing options...
bongo Posted August 16, 2005 Share Posted August 16, 2005 Which fields are you trying to change? <{POST_SNAPBACK}> Im trying to insert new fields, because i need more fields than the standard oscommerce. I want a little more information about my customers. Hope you can help me to make the script insert to the fields in the database. Regards Thomas Quote Link to comment Share on other sites More sharing options...
Paulie Posted August 16, 2005 Share Posted August 16, 2005 Hello, When a customer checks out using the Purchase Without Account option, the checkout_success.php page shows the following error: 1054 - Unknown column 'purchased_without_account' in 'field list' update orders set purchased_without_account = '1' where orders_id = '180' [TEP STOP] Does anyone know why this is happening and how it can be fixed? Thanks, Paul Quote Link to comment Share on other sites More sharing options...
xingqiyi Posted August 16, 2005 Share Posted August 16, 2005 Hello, When a customer checks out using the Purchase Without Account option, the checkout_success.php page shows the following error: Does anyone know why this is happening and how it can be fixed? Thanks, Paul <{POST_SNAPBACK}> It looks like you did not follow Step 5 in the Install_Instructions.txt file which asks you to execute these SQL statements on your database: ALTER TABLE customers ADD purchased_without_account TINYINT(1) UNSIGNED DEFAULT '0' NOT NULL AFTER customers_id; ALTER TABLE customers ADD INDEX (purchased_without_account); INSERT INTO configuration_group VALUES (40, 'Accounts', 'Configuration of Account settings', 40, 1); INSERT INTO configuration VALUES ('', 'Purchase Without Account', 'PWA_ON','true','Allow Customers to purchase without an account', 40, 1, '2003-04-08 13:07:44', '2003-04-08 12:10:51', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),'); ALTER TABLE orders ADD purchased_without_account TINYINT (1) UNSIGNED DEFAULT '0' NOT NULL; This is just a quick guess on my part! Quote Link to comment Share on other sites More sharing options...
Paulie Posted August 17, 2005 Share Posted August 17, 2005 It looks like you did not follow Step 5 in the Install_Instructions.txt file which asks you to execute these SQL statements on your database Thanks for your advice. I actually had run the SQL statements because it said that the table already existed. However, upon further inspection, I noticed that ALTER TABLE orders ADD purchased_without_account TINYINT (1) UNSIGNED DEFAULT '0' NOT NULL; was not in the database, so I executed that statement and now everything works! But now something strange has happened. Before, when a customer would use the Purchase Without Account feature, it would create a customer record (name, address, etc.). After executing the above statement, now when I tested an order using Purchase Without Account, the customer record is not created. Is that how it's really supposed to function? Thanks, Paul Quote Link to comment Share on other sites More sharing options...
VPSsupport Posted August 17, 2005 Share Posted August 17, 2005 Hi, Have recently installed PWA v0.82 and it appears to work fine. Although when you go into the admin panel - customer -customer orders - edit and update this page (with the notify customer box checked), the customer receives a blank email. This happens for registered customers and those that are in the database via the purchased without account method. Why does this happen? Has anyone else experienced this after using this addon? Thanks Clive Quote Regards, Clive Link to comment Share on other sites More sharing options...
wheeloftime Posted August 18, 2005 Share Posted August 18, 2005 Thanks for your advice. I actually had run the SQL statements because it said that the table already existed. However, upon further inspection, I noticed that ALTER TABLE orders ADD purchased_without_account TINYINT (1) UNSIGNED DEFAULT '0' NOT NULL; was not in the database, so I executed that statement and now everything works! But now something strange has happened. Before, when a customer would use the Purchase Without Account feature, it would create a customer record (name, address, etc.). After executing the above statement, now when I tested an order using Purchase Without Account, the customer record is not created. Is that how it's really supposed to function? Thanks, Paul <{POST_SNAPBACK}> That's how it is supposed to function, remember it is called Purchase Without Account. In the end you only have an order which has all the customer details needed, the temporarily customer account gets deleted after a successful checkout. Quote Link to comment Share on other sites More sharing options...
dcmwai Posted August 18, 2005 Share Posted August 18, 2005 Any plan for a new version? Quote Link to comment Share on other sites More sharing options...
Guest Posted August 20, 2005 Share Posted August 20, 2005 Hi Could you tell us how to ?move? pwa and put it at the top of our page? Thank you https://www.pcplanetsales.co.uk/pcplanet/login.php Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.