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

Remove option 2 ??

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

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.

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.

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.

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

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 ?

Yup. The same thing threw me too. Like Robsta says.. ensure your currency is set to 1.00.

I think I had the same problem. Add an item into the catagory, IIRC it solved my issue.

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

I tried this and they still look pretty poor compared to using say the classic skin

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

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

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 ?

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.

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

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

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

Its a very small mod in includes/session.inc.php. takes about 30 seconds to fix. I did mine yesterday

I've just had a quick look in Veiwcat.tpl, it will be tonight when I get home before I can make any changes. I'd have to do it on my test system 1st. What changes would I need to make to the html.. nothing obvious jumps out at me. Thanks again

Guys. My site went live last week.. thanks for all your help. I've now been handed another one to bring up to tidy up and bring up to scratch.. it seems I'm now the company cubecart expert .. lol My question, when entering a master catagory, you are presented with a folder view of the sub catagories. Is it possible to change this to a list view. Thanks

I have the same problem with the channel islands, no one came back with an answer. Luckily for me, I only needed to tax zones.. one for the UK at 15% and one for the channel Islands at 0% Maybe you might want to see if there are any commercial mods available. They tend to be very reasonably priced at about $20, it's whether or not you can find one to solve your problem .