Jump to content

keat

Member
  • Posts

    1,614
  • Joined

  • Last visited

  • Days Won

    27

Everything posted by keat

  1. 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.
  2. 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.
  3. 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']));
  4. 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
  5. 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
  6. keat

    Force choice

    Remove option 2 ??
  7. 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 **)
  8. 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
  9. The way I've overcome this is as follows. Create a dummy account with a simple password, ie 12345 Launch PHP admin (if you have access) and open the table "Customers" Browse this table and find the dummy customer you just created. Under the column "password" highlight and copy the haxadecimal string.. something like (123FF4DEABC33CC5A77D) Paste this string to a text file for future reference. Now browse the same column and find your customer. Overwrite his password string with the one you copied from the dummy account, and execute. Your customer, now has the password "12345", so he should now be able to log in and change it. No doubt there is a better way, and someone will be along to explain.
  10. Is anyone aware of a mod, that will allow me to export a sales inventry every week. I guess I could do this with an SQL export and MS Access Database maniuplation, but my CC owner is not going to be able to do this, so a Mod in the admin control panel would be good.
  11. I had the same problem. As far as I can tell, you can only apply tax to the one country. You cannot apply tax at one rate for UK, another rate for France etc etc. If you only want to apply tax to the UK, then you should be OK with the single tax band, however, Channel Islands may cause you a problem. Alternatively, I could put you in touch with a cubecart coder in the UK, who charges very good rates. He wrote me a custom script for carriage in 4 bands at different sale values, in under a week.
  12. Hi Folks. Me again. I've seen somewhere a mod, that allows CC to pass the cart inventry to Paypal, but can't remember where. Any ideas where I've seen it. TIA. Keat
  13. Well it seems this is definately the cause. Secpay, have removed the digest checking from my account, and everthing is working. Apparently, they have requested Cubecart impliment this in the secpay gateway, and are now suggesting that I do the same. Does anyone know, if there are any plans to impliment this in the gateway ?
  14. Yup. The same thing threw me too. Like Robsta says.. ensure your currency is set to 1.00.
  15. I think I had the same problem. Add an item into the catagory, IIRC it solved my issue.
  16. Guys n Gals I'm in the final stages of yet another CC3.18 e-commerce site (my 3rd one) I've created a secpay/paypoint account for the customer, but I'm unable to get secpay to accept a transaction. I get a message "Digests do not match, Possible fraud" I've tested with an older secpay account, and this one works. Having contacted secpay, it would appear that they implimented some new security features back in January, the new account is subject to these new security measures, whereas the older one isn't !! Am I doing something wrong?, or is there a more recent gateway I should upload. The current gateway has very little in the way of configuration in the GUI, other than enabled, test mode, and merchant ID. Thanks in advance
  17. I tried this and they still look pretty poor compared to using say the classic skin
  18. In your Admin control panel choose General settings - then near the bottom you will find Image settings - the last setting here should be something like image quailty and then under it 60-80 recommended - set the figure here to say 80 and save settings (at the bottom of the page) You will need to delete the image from the product page and then add it back from your uploads folder. Hope this helps Jim I tried all this.. even tried increasing the image quality to 999, but it still does the same. It looks like it's something to do with the ArwenBlue skin that I'm using. If I switch back to the classic skin, the thumbnails look OK. I have a way to overcome this.. but it's not ideal. Copy the images into the thumbs folder, and rename them.. seems to work. But only after modifying the product
  19. Guys. My thumbnail images are really pixellated. when you enter into a product, the image is nice a clear, just the thumbnails are very poor. From what I can see, the thumbnails are reduced in size to become a thumbnail, but then the cubecart enlarges this thunmbnail image to make it look really poor. Any ideas. Thanks in advance
  20. Well it gets better. I've modified reg.tpl, so it now contains the extra field. I figured out in PHP admin, how to add an additional data field, but I can't get it to populate the database. Am I missing something obvious ?
  21. OK. this is what I found. If you place an order.. then go into the admin section and view the same order. It has a status of pending.. at this point, the items remain in stock. If you change the status to completed.. the items remain in stock. They only come out of stock when the status is changed to processing. On my live system, I can see orders with a status of processing, and these have had no interaction from me. So the only thing I can come up with is this.. Something in the payment process changes the order status from pending to processing.. at this point, the items come out of stock. If you skip this step, then the items remain in stock.
  22. Very Interesting. I see what you mean. Test product 2 is showing as 3 in stock. I just ordered all 3, and completed my order through to Postal form. However, when I go back into the store, it still shows as having 3 in stock. So I went and did the same on my test system, and guess what.. it does the same.. Having said that.. my test isn't clean, so I'll do a fresh install this afternoon, and let you know what happens
  23. I just realised. It's not much use in adding an extra field in the Register form, as you'd also need to add one to the Database table.. and this is way out of my league
  24. Guys, does anyone have an answer to this question please. I've been asked today, to include an additional field (company name) on the registration form. Thanks In Advance
  25. Its a very small mod in includes/session.inc.php. takes about 30 seconds to fix. I did mine yesterday
×
×
  • Create New...