keat
-
Posts
1,614 -
Joined
-
Last visited
-
Days Won
27
Posts posted by keat
-
-
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.
-
I have FileZilla and Cube Cart 3.0.17
now the details in help for SteGround tell me that my port is 21...
I have tried every combination I can think of to insert for server address and port...then use my website password.
When I try to sign into FileZilla it keep telling me connection failed and says something about an incorrect port.
Any ideas of what I may be doing incorrectly?
this is what the FTP help section of SiteGround tells me:
Once you have the FileZilla client already downloaded and activated on your computer, enter your domain name in the address field (you can also use the server's IP address). The username and the password you need to type in are the same as the ones you use to log in to your cPanel. The FTP port is 21.
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.
-
Does anybody now how to Sort Products alpahetically in each category.
Thanks
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
-
When customer places a new order i don't get emails, how to fix this
I have to check again and again in Admin cube cart, for new order placed which is not convenient.
I appreciate if some one can help me on this
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
-
Hi Guys,
I'm really stuck I have this error whenever anyone tries to click through to view a product description in my shop.
All the categories and information pages are working just fine.
MySQL Error Occured
1054: Unknown column 'mid.value_id' in 'on clause'
QUERY = SELECT DISTINCT bot.assign_id, value_name FROM CubeCart_options_mid AS mid, CubeCart_options_bot AS bot INNER JOIN CubeCart_options_bot ON mid.value_id = bot.value_id AND bot.product = '654' ORDER BY assign_id AS
I've upgraded all my files as I was running CC 3.0.15. Its now upgraded to 3.0.19.
I'm forced to conclude the fix to this will require going into the database itself and editing however I have no idea what or where.
All the prices have lost the £ symbol as well. As this happened at the same time I think they are linked.
I preformed a database check and repair through cpanel.
Can someone help or know what I will need to do to fix this?
many Thanks
Patricia
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.
-
Hi guys..
i need some template related help here..
take a look at my site
at the bottom i have 2 white horizontal rows/lines, is there a quick easy (html or any other) fix to make these rows transparent with the rest of the background?
thx for your help!
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.
-
I added "more images" to one product just to test it out. I then removed the additional images from that product but the "[+] More Images" link is still on that product's page! Any one know how to get rid of this darn link?? arrgh!
Thank you.
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.
-
Thanks for the reply. Company details are being passed to the database upon registration, and can actually see them in the admin control panel "View Customers", but they are not being posted in the confirmation email.
$query = "SELECT * FROM
$text = sprintf($lang['front']['orderSuccess']['inv_email_body_1'],
priceFormat($order[0]['prod_total']),
$order[0]['company'],
$order[0]['name'],
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.
-
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']));
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']));
-
Guys.
I've added the "Company Details" field to the registration and profile of my site, but I'd like the company info to also show up on the order confirmation that we receive when a customer places an order.
I guess it's just a matter of adding the particular database field to the order confirmation.. but which file handles sends the order confirmation to our inbox.
Thanks in advance
Keat
Hi Keat,
The file that sends out the emails is the "orderSucess.inc.php" file which is located in:
your-store-setup-files/includes/orderSuccess.inc.php
however in order to achieve what you want it to achieve quite rightly you will have to add the fileds to the database - but there is a bit more work involved than just adding new fields. what you will need to do in order to get it completely working is as follows:
Add the Company Details field to the database,
Write the companies details to the database at the same time as CubeCart writes the information to the database about the customer. So this would be in the registration file.
Then inside the orderSuccess.inc.php you will need to modify the MySQL statement to tell it to also select the Company_Details field
Once the MySQL field is modified you will need to add the contents of the Company_Details field the body of the email in the same way cubecart adds the other information.
Alternatively what you could do is get the customer to input there company details into the Company Details box every time they place a new order - Then write the contents of the Company Details box to a session cookie or querystring and pick either up inside the orderSucess.inc.php page.
I would recommend the first method.
Thanks
Rob
Hi Rob.
Thanks for the reply. Company details are being passed to the database upon registration, and can actually see them in the admin control panel "View Customers", but they are not being posted in the confirmation email.
The people who input the data from cubecart into our invoicing system are not particularly IT savvy, so I'd rather they didn't have to open the admin control panel, just to find the comapny name.
I can see all sorts of problems occuring.
Now I know which file I'm looking at, I can continue playing.
Thank You..
Of course I'll keep you posted
-
Folks. sorry to bump this, but resolving this issue, would be a great help for me if I could get it done this week.
I just need to know, which file executes the "Sale Confirmation" email.. as below, I'm guessing I could figure the rest out myself.
> Dear CubeCart Store Administrator,
>
> New Order Number: 090715-151908-6168 placed on Jul 15 2009, 15:19 PM
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~
> Name: mr John Doe
> E-Mail: [email protected]
> Subtotal: £14.70
> Postage & Packaging: £3.95
> Tax: £2.80
> Grand Total: £21.45
> ~~~~~~~~~~~~~~~~~~~~~~~~~~
>
> Invoice Address:
> mr John Doe
> unit 3 xxxxx
> xxxxxxx, west felton
> nr oswestry
> shropshire
> sy11 xxx
> United Kingdom
>
> Shipping Address:
> mr John Doe
> unit 3 xxxxx
> xxxxxxx, west felton
> nr oswestry
> shropshire
> sy11 xxx
> United Kingdom
>
> Payment Method: PayPal
> Shipping Method: Free for Orders Over 45 ~~~~~~~~~~~~~~~~~~~~~~~~~~
>
>
> Order Inventory:
> Product: Blue Female Spade 4.8mm Fully Insulated
> Options: Order - 100
> Quantity: 2
> Product Code: WT11
> Price: £6.30
-
Hi
How to force a member to choice 1 option?
like here:
My config:
Tks for help
Remove option 2 ??
-
Remove the product from the additional category once and they will all disappear resolving the issue. Re-add it with a single click, close the dialog box. Add only one at a time closing the box each time, as when you change pages after adding or double click on an 'add' button it adds it a second time.
v3 bug.
Thanks. I tryed it and it seemed to work but I have run in to one other issue....
After removing the product I noticed the the item count did not reset. Is there any way to correct this issue with out having to take everthing down and starting over?
To take a look at what I am refering to you can look at my site that is posted on my profile.
I also have an issue with admin view of store in offline mode but I found the post where this was addressed, just haven't done it yet.
Once again thank you for your help.
You can correct this in PHPAdmin.
Browse the Category table, find the paaricular category, and change the key "noProducts" to the ciorrect amount. (** Number of products **)
-
Guys.
I've added the "Company Details" field to the registration and profile of my site, but I'd like the company info to also show up on the order confirmation that we receive when a customer places an order.
I guess it's just a matter of adding the particular database field to the order confirmation.. but which file handles sends the order confirmation to our inbox.
Thanks in advance
Keat
I NEED HELP - ANYONE PLEASE
in Technical Help
Posted
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