keat

Sorted.. Thanks

Hi Robsta I'm looking for the actual php file which generates the email that we recieve when a customer places an order. For some reason, it doesn't include the customer telephone number. I'm looking to modify the script, so that it would.. making the job for the girls inputting into our system a little easier. I've done this once, but can't rememeber which file I modified.

Guys A while ago, i successfully modified the sale email notification, so that it included the customer comments. I now want to do the same, so that it includes the customers telephone numbers, but I cannot for the life of me remember which file I modified. I thought it was ordersucces.inc.php, but no amount of modifcation will do what I want it to do, so I'm guessing it was a different file. Foolishly, I didn't take notes. Could someone remind me which file gererates and sends this email please. Dear CubeCart Store Administrator, New Order Number: DBO-100312-123801-8604 placed on Mar 12 2010, 12:38 PM ~~~~~~~~~~~~~~~~~~~~~~~~~~ Company: mr Name: mr k r E-Mail: Subtotal: £1.50 Coupon Discount: £0.00 Postage & Packaging: £3.95 Tax: £0.95 Grand Total: £6.40 ~~~~~~~~~~~~~~~~~~~~~~~~~~ Invoice Address: mr mr k r 1 1 1 1 1 United Kingdom Shipping Address: mr k r 1 1 1 1 1 United Kingdom Payment Method: PayPal Shipping Method: Customer comments: zzzz ~~~~~~~~~~~~~~~~~~~~~~~~~~ Order Inventory: Product: Maintenance Spray Quantity: 1 Product Code: WC1 Price: £1.50

Should the customer comments appear on the email notification that the admin receives. I'm not seeing them anywhere, but I'm sure we used to. ??

Michael. Unless anyone can suggest a mod, then I'd say that you would have to create a new option called multiples, or bag quantities. EG you already have an option called colours... red, yellow, green etc so create another one called multiples. Take a look at this page.. the customer has the option to buy 100, 1000 or 55,000 and then any multiples of these denominations. 5 x 100, 2 x 1000 or 7 x 55,000 hope this helps http://www.cabletiesonline.co.uk/cable-tie...5mm/prod_1.html

I'm not sure that your question comes across very well. I guess you mean.. eg. items sold in singles, or items sold in full boxes of 10. Customer can choose any multiple of single items, 1,2,3,4,5 etc etc or can choose any multiples of 1 full box of items 1 x 10, 2 x 10, 3 x 10 If so, then yes, but you have to create a product option for the box of items. If this is what you mean, drop an answer, and I'll try to explain in detail how it's done. Pretty simple

Guys I found my own answers, however, someone else might want to do this so here goes. To add a prefix to order numbers and or to remove the last 4 digit random numbers: Applies to CC V3. It might come in handy if like me, you want to differentiate between multiple cubecart orders from 2 different sites, and using the same payment gateway. Edit \includes\content\gateway.inc.php Find the line $cart_order_id = date("ymd-His-").rand(1000,9999); Change to $cart_order_id = "prefix-". date("ymd-His"); Prefix is your prefix and .rand(1000,9999) is the waste of time random number on the end of each order. Your order number will now look similar to ABC-090921-123456. To fix the delete order problem edit admin/orders/index.php Change the line // delete document if(isset($_GET['delete']) && $_GET['delete']>0){ to // delete document if(isset($_GET['delete']) && $_GET['delete']>""){

Thanks for the answer, I actually found this earlier this afternoon, whilst trawling the forums. So I've created a prefix, and dropped the last 4 digit random number (waste of time having that) All my orders are now showing Prefix-date-time as the order number. I have my email filter in place, and all orders showing the prefix are being sent to the relevent people. This has solved my problem exactly as I wanted it, but created another. Orders cannot be deleted from the admin control panel.

Guys. I have 2 cubecart sites, both paying into the same SecPay account. To make life easier, is it possible to change the way the automated order number is generated. If I could prefix it with something, I could tell at a glance which shop the payment came from. I could also create an email filter and ensure the email gets directed to the correct department

Guys. We have a custom mod written that charges shipping based on postcodes. We ship parcels upto 30kg, so everyone goes out the same route. Customer in Eire, do not have a postcode, so our shipping mod does not charge them carriage (ooops) I've asked the guy who wrote the mod, if he can come up with something. My question here is: How difficult/easy would it be to re-write the mod, or whatever we need to do, so that when a customer chooses Eire has his country in the drop down. Cubecart would allocate a made up postcode (say N/A) and then grey out the postcode box, so that he couldn't change it. This would then allow us to run the custom shipping mod based on a postcode.

Silly question... but you are using the username and password for the Hosting CPanel, and not the Cubecart Username?password. I'm not farmiliar with FileZilla. However, WSFTPLE (Light Edition) is free. It was discontinued but you can still find it on some of the University sites etc, might be worth trying this or something similar.

It's probably some manipulation in viewcat.inc.php, and I'm sure someone will know exactly where ??

It was something on the server end. My hosts had a crash last week, and they say some php extensions must have corrupted. Thanks Guys

what settings do you have in your admin control panel. also are you confident that it's not being blocked as spam by your mail server, maybe try temporarily configuring another email address?

Sorry for the long winded logs.. but they also include other errors. I'm still waiting for the host to tell me what's wrong. [01-Sep-2009 16:31:48] PHP Warning: PHP Startup: Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-non-zts-20060613/suhosin.so' - /usr/local/lib/php/extensions/no-debug-non-zts-20060613/suhosin.so: cannot open shared object file: Permission denied in Unknown on line 0 [01-Sep-2009 16:31:48] PHP Warning: PHP Startup: Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-non-zts-20060613/pdo.so' - /usr/local/lib/php/extensions/no-debug-non-zts-20060613/pdo.so: file too short in Unknown on line 0 [01-Sep-2009 16:31:48] PHP Warning: PHP Startup: Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-non-zts-20060613/pdo_sqlite.so' - /usr/local/lib/php/extensions/no-debug-non-zts-20060613/pdo_sqlite.so: cannot dynamically load executable in Unknown on line 0 [01-Sep-2009 16:31:48] PHP Warning: PHP Startup: Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-non-zts-20060613/sqlite.so' - /usr/local/lib/php/extensions/no-debug-non-zts-20060613/sqlite.so: cannot open shared object file: No such file or directory in Unknown on line 0 [01-Sep-2009 16:31:48] PHP Warning: PHP Startup: Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-non-zts-20060613/pdo_mysql.so' - /usr/local/lib/php/extensions/no-debug-non-zts-20060613/pdo_mysql.so: cannot read file data: Is a directory in Unknown on line 0 [01-Sep-2009 22:52:20] PHP Warning: PHP Startup: Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-non-zts-20060613/suhosin.so' - /usr/local/lib/php/extensions/no-debug-non-zts-20060613/suhosin.so: cannot open shared object file: Permission denied in Unknown on line 0 [01-Sep-2009 22:52:20] PHP Warning: PHP Startup: Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-non-zts-20060613/pdo.so' - /usr/local/lib/php/extensions/no-debug-non-zts-20060613/pdo.so: file too short in Unknown on line 0 [01-Sep-2009 22:52:20] PHP Warning: PHP Startup: Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-non-zts-20060613/pdo_sqlite.so' - /usr/local/lib/php/extensions/no-debug-non-zts-20060613/pdo_sqlite.so: cannot dynamically load executable in Unknown on line 0 [01-Sep-2009 22:52:20] PHP Warning: PHP Startup: Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-non-zts-20060613/sqlite.so' - /usr/local/lib/php/extensions/no-debug-non-zts-20060613/sqlite.so: cannot open shared object file: No such file or directory in Unknown on line 0 [01-Sep-2009 22:52:20] PHP Warning: PHP Startup: Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-non-zts-20060613/pdo_mysql.so' - /usr/local/lib/php/extensions/no-debug-non-zts-20060613/pdo_mysql.so: cannot read file data: Is a directory in Unknown on line 0 [02-Sep-2009 00:10:20] PHP Warning: PHP Startup: Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-non-zts-20060613/suhosin.so' - /usr/local/lib/php/extensions/no-debug-non-zts-20060613/suhosin.so: cannot open shared object file: Permission denied in Unknown on line 0 [02-Sep-2009 00:10:20] PHP Warning: PHP Startup: Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-non-zts-20060613/pdo.so' - /usr/local/lib/php/extensions/no-debug-non-zts-20060613/pdo.so: file too short in Unknown on line 0 [02-Sep-2009 00:10:20] PHP Warning: PHP Startup: Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-non-zts-20060613/pdo_sqlite.so' - /usr/local/lib/php/extensions/no-debug-non-zts-20060613/pdo_sqlite.so: cannot dynamically load executable in Unknown on line 0 [02-Sep-2009 00:10:20] PHP Warning: PHP Startup: Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-non-zts-20060613/sqlite.so' - /usr/local/lib/php/extensions/no-debug-non-zts-20060613/sqlite.so: cannot open shared object file: No such file or directory in Unknown on line 0 [02-Sep-2009 00:10:20] PHP Warning: PHP Startup: Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-non-zts-20060613/pdo_mysql.so' - /usr/local/lib/php/extensions/no-debug-non-zts-20060613/pdo_mysql.so: cannot read file data: Is a directory in Unknown on line 0 [02-Sep-2009 00:20:40] PHP Warning: PHP Startup: Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-non-zts-20060613/suhosin.so' - /usr/local/lib/php/extensions/no-debug-non-zts-20060613/suhosin.so: cannot open shared object file: Permission denied in Unknown on line 0 [02-Sep-2009 00:20:40] PHP Warning: PHP Startup: Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-non-zts-20060613/pdo.so' - /usr/local/lib/php/extensions/no-debug-non-zts-20060613/pdo.so: file too short in Unknown on line 0 [02-Sep-2009 00:20:40] PHP Warning: PHP Startup: Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-non-zts-20060613/pdo_sqlite.so' - /usr/local/lib/php/extensions/no-debug-non-zts-20060613/pdo_sqlite.so: cannot dynamically load executable in Unknown on line 0 [02-Sep-2009 00:20:40] PHP Warning: PHP Startup: Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-non-zts-20060613/sqlite.so' - /usr/local/lib/php/extensions/no-debug-non-zts-20060613/sqlite.so: cannot open shared object file: No such file or directory in Unknown on line 0 [02-Sep-2009 00:20:40] PHP Warning: PHP Startup: Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-non-zts-20060613/pdo_mysql.so' - /usr/local/lib/php/extensions/no-debug-non-zts-20060613/pdo_mysql.so: cannot read file data: Is a directory in Unknown on line 0 [02-Sep-2009 00:55:12] PHP Warning: PHP Startup: Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-non-zts-20060613/suhosin.so' - /usr/local/lib/php/extensions/no-debug-non-zts-20060613/suhosin.so: cannot open shared object file: Permission denied in Unknown on line 0 [02-Sep-2009 00:55:12] PHP Warning: PHP Startup: Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-non-zts-20060613/pdo.so' - /usr/local/lib/php/extensions/no-debug-non-zts-20060613/pdo.so: file too short in Unknown on line 0 [02-Sep-2009 00:55:12] PHP Warning: PHP Startup: Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-non-zts-20060613/pdo_sqlite.so' - /usr/local/lib/php/extensions/no-debug-non-zts-20060613/pdo_sqlite.so: cannot dynamically load executable in Unknown on line 0 [02-Sep-2009 00:55:12] PHP Warning: PHP Startup: Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-non-zts-20060613/sqlite.so' - /usr/local/lib/php/extensions/no-debug-non-zts-20060613/sqlite.so: cannot open shared object file: No such file or directory in Unknown on line 0 [02-Sep-2009 00:55:12] PHP Warning: PHP Startup: Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-non-zts-20060613/pdo_mysql.so' - /usr/local/lib/php/extensions/no-debug-non-zts-20060613/pdo_mysql.so: cannot read file data: Is a directory in Unknown on line 0 [02-Sep-2009 03:03:03] PHP Warning: PHP Startup: Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-non-zts-20060613/suhosin.so' - /usr/local/lib/php/extensions/no-debug-non-zts-20060613/suhosin.so: cannot open shared object file: Permission denied in Unknown on line 0 [02-Sep-2009 03:03:03] PHP Warning: PHP Startup: Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-non-zts-20060613/pdo.so' - /usr/local/lib/php/extensions/no-debug-non-zts-20060613/pdo.so: file too short in Unknown on line 0 [02-Sep-2009 03:03:03] PHP Warning: PHP Startup: Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-non-zts-20060613/pdo_sqlite.so' - /usr/local/lib/php/extensions/no-debug-non-zts-20060613/pdo_sqlite.so: cannot dynamically load executable in Unknown on line 0 [02-Sep-2009 03:03:03] PHP Warning: PHP Startup: Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-non-zts-20060613/sqlite.so' - /usr/local/lib/php/extensions/no-debug-non-zts-20060613/sqlite.so: cannot open shared object file: No such file or directory in Unknown on line 0 [02-Sep-2009 03:03:03] PHP Warning: PHP Startup: Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-non-zts-20060613/pdo_mysql.so' - /usr/local/lib/php/extensions/no-debug-non-zts-20060613/pdo_mysql.so: cannot read file data: Is a directory in Unknown on line 0 [02-Sep-2009 06:36:53] PHP Warning: PHP Startup: Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-non-zts-20060613/suhosin.so' - /usr/local/lib/php/extensions/no-debug-non-zts-20060613/suhosin.so: cannot open shared object file: Permission denied in Unknown on line 0 [02-Sep-2009 06:36:53] PHP Warning: PHP Startup: Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-non-zts-20060613/pdo.so' - /usr/local/lib/php/extensions/no-debug-non-zts-20060613/pdo.so: file too short in Unknown on line 0 [02-Sep-2009 06:36:53] PHP Warning: PHP Startup: Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-non-zts-20060613/pdo_sqlite.so' - /usr/local/lib/php/extensions/no-debug-non-zts-20060613/pdo_sqlite.so: cannot dynamically load executable in Unknown on line 0 [02-Sep-2009 06:36:53] PHP Warning: PHP Startup: Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-non-zts-20060613/sqlite.so' - /usr/local/lib/php/extensions/no-debug-non-zts-20060613/sqlite.so: cannot open shared object file: No such file or directory in Unknown on line 0 [02-Sep-2009 06:36:53] PHP Warning: PHP Startup: Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-non-zts-20060613/pdo_mysql.so' - /usr/local/lib/php/extensions/no-debug-non-zts-20060613/pdo_mysql.so: cannot read file data: Is a directory in Unknown on line 0

Folks. Any ideas what's causing these logs ? [02-Sep-2009 18:31:23] PHP Warning: PHP Startup: Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-non-zts-20060613/suhosin.so' - /usr/local/lib/php/extensions/no-debug-non-zts-20060613/suhosin.so: cannot open shared object file: Permission denied in Unknown on line 0 I currently have a ticket open with my host. Thanks Keat

Until someone comes along with a definitive answer, from what I've learnt, the tables "options_bot" and "options_mid" are all to do with your product options. Maybe try playing around with a product option, see if you can get to the bottom of it.

Hi Folks. A few weeks back, we had an issue where customers were reporting that they couldn't see the shopping cart on one of our CC3 sites. I've just had a call today, to report the same problem on a sister site. Has anyone seen anything like this before ?? Looking at the attached screen shot, the whole cart section is missing... nothing there what so ever, not even a blank space to indicate it was missing.. It's as if the shopping cart doesn't exist. Maybe the code isn't being loaded.. could something be blocked on the customers browser? Until I can get to the bottom of it, I've created a new part with a link to the cart, but this is only a temporary fix. Incidentally, when I look, everything is OK. The customer is using IE8, and wev'e tried it in and out of compatibilty mode. The site in question this time is www.cabletiesonline.co.uk Customer screen shot attached. ScreenShot.pdf

I've seen something similar when hiding this sort of stuff. Try looking at Yourskin/stylesheets/style.css look for something along the lines ".txtCopyright........." Where it says "align:center" add ";colour:#fff" ................align:center;colour:#fff". It may take some experimenting with colour codes. also I believe skin/global/index.tpl may carry some template copyright stuff. It sounds vague, but I'm still learning this stuff myself. P.S You can rename the TPL file to *.html, and edit with your normal html editor. Then rename it back to *.tpl before you upload it.

From PHP Admin, You can open the Inventry table, find you troublesome product. Edit and change the NoImages value. Not sure if this is the correct proceedure, but it works.

I've copied various parts of your past messages to assist: Seeing the custom registration data in the View Customers admin screen implies you have successfully installed a "Custom Registion Info" modification of some sort. As such, the custom data is getting saved to the _customer table. What you now need to determine is the accurate table column name holding the desired data (Company Name may be in a column called 'companyName' or maybe 'customData1'. You will need to look directly at the Cubecart database _customers table.) The query is fetching ALL data (the asterisk), so there's no need to specifically ask for the new column(s) *unless* the new data is in a separate table - but it doesn't sound like it. The sprintf() function calls a string template from your language file. In the file /language/yourlanguage/lang.inc.php, look for the array $lang['front']['orderSuccess']['inv_email_body_1']. (It's a huge file, look carefully.) The string template will have lots of %s placeholders. You will need to add more text to the template where you want the Company Name to appear, followed by a placeholder. For example: Company Name: %s. It is critically important that the order and count of data items (..., total price, company, name, ...) align accurately with the string template and number of placeholders as sprintf() replaces the first placeholder with the first item of data in the sprintf() list ('name' in this case) and proceeds on from there. I hope I've given you more clues to solve your issue. Hi. Yes I have implimented company details upon registration. They appear in a new field called "company" in the "Customer" table. They appear upon registration, in the admin panel, they can also be seen in the database, so that part is working OK. Getting them on the "Order Confirmation" email, is just proving a little too tricky for my knowledge level. This morning, I set the wheels in motion to have this done by someone who understands Cubecart (PHP) better than I do. I had been given very similar information by the chap who's doing the work for me, but having spent a good few hours again last night, I finally submitted and gave in. Thanks for the reply

Hi Jose. I don't think your question is coming across very well. It's difficult to understand what it is your'e try to acheive.

I give in. I'll pay someone to do this for me.. Unfortunately, when I do get to the bottom of it, It would be unfair of me to divulge how it's done. Thanks to those who answered, thanks to those who thought about it.

Having had another hour again today, I'm still none the wiser. Looking at the SQL query at the top, I guess the query is looking at the table "Customer", otherwise it wouldn't know where to pull the customer data from.. so why when I add the additional field "$order[0]['company']," does it not include the company details in the confirmation email. The data is there in the Database, and can be clearly seen from Cubecart admin "View Customer". I've also included it in the "Great News..........Company Registration" email I'm obviously missing something fundamental but what.

I had an hour or so playing with orderSuccess.php, but didn't really get anywhere. I'm sort of guessing i need to modify the following lines, (in red) and I thought I was OK with SQL, but I'm not as clever as I thought i was. $query = "SELECT * FROM ".$glob['dbprefix']."CubeCart_order_sum INNER JOIN ".$glob['dbprefix']."CubeCart_customer ON ".$glob['dbprefix']."CubeCart_order_sum.customer_id = ".$glob['dbprefix']."CubeCart_customer.customer_id WHERE ".$glob['dbprefix']."CubeCart_order_sum.cart_order_id = ".$db->mySQLSafe($cart_order_id); (add something along the lines SELECT from Cubecart_Customers.company) $order = $db->select($query); include_once($glob['rootDir']."/includes/currencyVars.inc.php"); $text = sprintf($lang['front']['orderSuccess']['inv_email_body_1'], $order[0]['name'], $cart_order_id, formatTime($order[0]['time']), $order[0]['name'], priceFormat($order[0]['subtotal']), priceFormat($order[0]['total_ship']), priceFormat($order[0]['total_tax']), priceFormat($order[0]['prod_total']), $order[0]['company'], $order[0]['name'], $order[0]['add_1'], $order[0]['add_2'], $order[0]['town'], $order[0]['county'], $order[0]['postcode'], countryName($order[0]['country']), $order[0]['name_d'], $order[0]['add_1_d'], $order[0]['add_2_d'], $order[0]['town_d'], $order[0]['county_d'], $order[0]['postcode_d'], $order[0]['country_d'], str_replace("_"," ",$order[0]['gateway']), str_replace("_"," ",$order[0]['shipMethod']));