Jump to content

  • You cannot start a new topic
  • You cannot reply to this topic

Vat Change - Keep Same Prices Rate Topic   - - - - -

 
  • Flow
  • Super Duper and Amazingly Sexy Senior
  • Members
  • Join Date: 13-Oct 10
  • 2351 posts

Posted 30 June 2020 - 04:20 PM #1

Hi, we have an upcoming VAT change but we would like to keep our prices on the storefront the same. 

 

I thought I could just change the VAT and than use an import to bulk raise the prices by a certain % so they would become the same again at the front end. However, this won't work for option modifiers.

 

We are on cs-cart 4.6x and prices excl VAT in the system.

 

Would anybody know a trick on how to do this best?

 

Any help would be greatly appreciated.


When life hands you lemons, bring on the Tequila baby!


 
  • Darius
  • Douchebag
  • Members
  • Join Date: 20-Apr 08
  • 3365 posts

Posted 01 July 2020 - 05:31 AM #2

Maybe global price update by fixed amount of %?

 

/admin.php?dispatch=products.global_update



 
  • Flow
  • Super Duper and Amazingly Sexy Senior
  • Members
  • Join Date: 13-Oct 10
  • 2351 posts

Posted 01 July 2020 - 05:34 AM #3

Yeah that was my idea, but then modifiers don't change I assume?


When life hands you lemons, bring on the Tequila baby!


 
  • Darius
  • Douchebag
  • Members
  • Join Date: 20-Apr 08
  • 3365 posts

Posted 01 July 2020 - 05:40 AM #4

Not sure, not tested

 

Yeah that was my idea, but then modifiers don't change I assume?

 



 
  • johnbol1
  • Never Re
  • Members
  • Join Date: 23-Feb 10
  • 4817 posts

Posted 01 July 2020 - 04:53 PM #5

Export option modifiers maybe and manipulate in excel too ?

https://forum.cs-car...rice-modifiers/


Custom printed hi visibility clothing sale the UK's online hivis safety shop
v4.5.2


 
  • Flow
  • Super Duper and Amazingly Sexy Senior
  • Members
  • Join Date: 13-Oct 10
  • 2351 posts

Posted 04 July 2020 - 08:30 AM #6

Export option modifiers maybe and manipulate in excel too ?

https://forum.cs-car...rice-modifiers/

 

I tried that but it was too tricky. In the end everyone took a brand and fixed it.... 

What I find very strange is that cs-cart used the products codes to import producs. Why doesn't it simply use the product ID? 

We had some products that apparantly had identical product codes which caused issues. 

Also some options seem to have broken - modifiers don't save so the options have to be created again. 

 

Anyway, I hope when we change back to the old VAT I have upgraded cs-cart and it will be easier. 


When life hands you lemons, bring on the Tequila baby!


 
  • tbirnseth
  • CS Cart Expert
  • Authorized Reseller
  • Join Date: 08-Nov 08
  • 11748 posts

Posted 04 July 2020 - 06:02 PM #7

They don't use product_id so you can import to new site.  However, correct behavior should be:

if product id column exists, import by product_id (this would also allow you to change the product_code)

else import by product code.

IMHO


EZ Merchant Solutions: Custom (USA based) B2B Development, Consulting, Development and Special Projects (get a quote here).
Commercial addons, payment methods and modifications to meet your business and operations needs.


 
  • The Tool
  • Been Here Way Too Long Member
  • Members
  • Join Date: 30-Mar 07
  • 3919 posts

Posted 05 July 2020 - 07:44 PM #8

Also for those that import files from suppliers, the product_id is not going to be available but instead the product_code.



 
  • tbirnseth
  • CS Cart Expert
  • Authorized Reseller
  • Join Date: 08-Nov 08
  • 11748 posts

Posted 05 July 2020 - 07:47 PM #9

yes that's why it's conditional upon whether it's present or not.  If a "Product id" column is there, use it, if not find it by "Product code".  Would work perfectly.  I've supplied a lot of people with a simply addon that acts as a pre-filter to allow them to change the product_code of imported products. They could have fixed this years ago....


EZ Merchant Solutions: Custom (USA based) B2B Development, Consulting, Development and Special Projects (get a quote here).
Commercial addons, payment methods and modifications to meet your business and operations needs.


 
  • The Tool
  • Been Here Way Too Long Member
  • Members
  • Join Date: 30-Mar 07
  • 3919 posts

Posted 05 July 2020 - 07:57 PM #10

Agreed.