Jump to content

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

Csv Export Rate Topic   - - - - -

 
  • azri445
  • Member
  • Members
  • Join Date: 06-Jan 18
  • 41 posts

Posted 17 February 2018 - 03:17 AM #1

We have shippin rate... and we woukd like to update it from our back end phpmyadmin using csv NOT manually update from cs-cart admin panel.

Currently we have rate for 13 country. Rather than updatig f4om back end panel ..let jut update from excel and make it as csv then import from phpmyadmin

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

Posted 17 February 2018 - 09:51 PM #2

Unfortunately, rates are a serialized array stored in the db.  To update, you would need to read the column, unserialize it, update the array values, serialize it and then write it back.

 

If you'd like a quick solution specific to this need, contact us via the link in my signature and we can whip somehting up for you over the weekend.  it would be a fairly simple CSV of:

Shipping ID

Dependency (C=cost, W=weight, I=items)

Value = value or value%


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.