keat

Ill have a play on a mirrored site first.

If you take a look at the following images, you'll note that the cart added the taxes correctly for the 10 fm transmitters. My total bill for the cart £119.40 I then applied the voucher, and my total bill for the cart is now £99.50, and allowed me to checkout. However, as already determined, my total voucher is really only worth £83.33. This means that there must be 2 issues with the gift card feature. 1. it wipes taxes from the cart 2. it allows the user to spend more credit than he actually has. http://www.cabletiefan.co.uk/webimages/pre-voucher.jpg http://www.cabletiefan.co.uk/post-voucher.jpg

I've finally convinced the staff to allow me to switch to 'email notification at processing', and will now spend the next week or so answering half baked questions. Lets see if this has any impact.

We are in and out of the cart all day, spread over about 6 users, so if this clears the cache each and everytime, then like you say, we'd be seeing this issue more frequently.

Could clearing the cache cause this. At the same time this customers order was wiped, I was updating a few admin folder files, and I performed a clear cache to have the chages take effect. I know for certain that this has not been the cause of the previous occurances, unless of course, there may be something in the background which performs a clear cache. Just a thought.

Looking in Google WebMaster Tools, I can see that my console is showing a number of structured data items. I don't recall doing anything to invoke this, so I can only assume it's google doing what it does best (snooping) Is there a method to have this data populated with the price, it can only be a good thing ..... can't it ??

Maybe related, may be not, but i'll document it for future cross ref. The IP address asscociated with this mornings occurance generated a mod security warning in apache error logs. However, this was 5 days ago, and may not neccesarily be the same PC. [Mon Apr 24 07:24:28.761134 2017] [:error] [pid 7471:tid 140356395943680] [client xx.xx.xx.xxx] ModSecurity: Access denied with code 403 (phase 2). String match within "/Proxy-Connection/ /Lock-Token/ /Content-Range/ /Translate/ /via/ /if/" at TX:header_name_via. [file "/etc/apache2/conf.d/modsec_vendor_configs/OWASP3/rules/REQUEST-920-PROTOCOL-ENFORCEMENT.conf"] [line "463"] [id "920450"] [rev "2"] [msg "HTTP header is restricted by policy (/via/)"] [data " Restricted header detected: /via/"] [severity "CRITICAL"] [ver "OWASP_CRS/3.0.0"] [maturity "9"] [accuracy "9"] [tag "application-multi"] [tag "language-multi"] [tag "platform-multi"] [tag "attack-protocol"] [tag "OWASP_CRS/POLICY/HEADER_RESTRICTED"] [tag "WASCTC/WASC-21"] [tag "OWASP_TOP_10/A7"] [tag "PCI/12.1"] [tag "WASCTC/WASC-15"] [tag "OWASP_TOP_10/A7"] [tag "PCI/12.1"] [hostname "www.domain.co.uk"] [uri "/"] [unique_id "WP2aHEc@D6pVULYvSfbINwAAAU4"]

I can confirm that 6.1.7 doesn't resolve this. We had another one this morning.

Using Notepad++ and scanning the whole of the cubecart download I find numerous instances of `cart_order_id` VARCHAR(18) If I changed these (using notepad++) en mass, to `cart_order_id` VARCHAR(30) , would this suffice for the update ? 422 hits in 27 files sorry, 15 hits in 3 files

I wouldn't mind knowing how to modify the upgrade script, this would save me a lot of trouble moving forward. Thanks

I have only 2 tax rules which is VAT at 20%, and Vat Free. We tax by country, UK and IOM are at 20%, Channel Islands and Eire at 0%. I applied 20% tax to the gift card. I also created a tax class just for gift cards at 0% and allocated this to a test voucher. When I purchased a voucher, it was tax free, but when I spent it, the order was still tax free. so again, the cart allowed me to checkout at £99.50 when it should have been £119.94. I logged in with my test account which is UK, so tax should have been applied to the basket total.

The problem is that characters are being chopped off during the upgrade process, resulting in order summary and order inventory not having the correct order_id, which in turn means that the customers order history doesn't work. I can get around this with an export and some fancy database editing, but it takes time, effort and prone to human error.

All cart items are configured exclusive of VAT, so vat added at the end of the transaction. If I purchase a gift voucher for £100, it charges vat at £16.67 and not £20.00 (20% vat rate) Total bill for a £100 gift voucher = £100. This means that the voucher is actually worth £83.33 plus vat at 20% (£16.67) total = £100. Now as the recipient of the voucher, I added £99.50's worth of goods to my basket so my final sub total should be £119.94. Using the voucher, the cart allowed me to checkout at £99.50, it didn't add any vat to the contents, and considering my voucher is only really worth £83.33 it didn't prompt me to pay the outstanding balance Any ideas

are they the standard email templates, I could maybe export them from my site as SQL and you import them back in ?? Alternatively, you could always build a quick empty shop and export them yourself. Ah.. just read your original notes that they were custom. maybe restoring the database tables to a new empty database might be the option.

Rather than being reactive, is it possible for me to be proactive and edit anything in the upgrade process. cart_order_id was always varchar =30 in CC3. In fact it's still varchar 30 in some of the V6 tables, but in other it's varchar 18. My remaining v3 sites all have at least 20 characters, which is causing me issues when I update. I still have one large V3 site to update, so making changes before the update would make life easier.

I had the same hooks on another cart, so just manually copied the code over.

Are the email templates saved in the database. I guess if you have a dbs backup you could get to them.

I just noticed that the PHP code in all my custom hooks is missing. I assume since updating to 6.1.7 Might be worth testing or noting. ?

They will have multiple tabs windows open, to other carts, and the office all share the same admin login. This didn't happen on 6.0.10. If I create multiple logins, will this alleviate the problem.

Since updating to 6.1.7 last week, users are complaining that thier admin sessions are timing out, resulting in them having to log in again. Is this a new feature ?

Could anyone recommend an sql command that would change the varchar(18) to varchar(30) on all tables which contain the column cart_order_id.

My standard tax class is called VAT, so adding <option selected="selected" value="1">VAT</option> appears to have done the trick. Much appreciated. Saves me having to explain to staff why the taxes don't tally.

I assume an edit in here somewhere ?? admin/skins/templates/product.index.php <div> <label for="tax_type">{$LANG.catalogue.tax_class}</label> <span> {if isset($TAXES)} <select name="tax_type" id="tax_type" class="textbox"> <option value="">{$LANG.common.please_select} &hellip;</option> {foreach from=$TAXES item=tax}<option value="{$tax.id}"{$tax.selected}>{$tax.tax_name}</option>{/foreach} </select> {else}{$LANG.catalogue.no_taxes_setup}{/if} </span> </div> I can do this for any product which I've forgotten to add tax, but I still keep making the same schoolboy error, so I'd prefer a the tax class to default to CucbeCart_tax_class .id=1 in the admin side when adding a new product.

Possibly, but I guess an edit in the admin skin would suffice, if i only knew how.

When adding the occasional new product, i keep forgetting to add VAT from the drop down. I've done this so many times, I care not to mention. Is there a way to have the cart default to VAT when adding a new product, rather than having to manually select it. ?