Shipping Tables insert question

For general questions and discussions specific to the AbleCommerce 7.0 Asp.Net product.
Post Reply
alkasber
Lieutenant, Jr. Grade (LT JG)
Lieutenant, Jr. Grade (LT JG)
Posts: 36
Joined: Thu May 15, 2008 2:50 pm
Location: Brazil

Shipping Tables insert question

Post by alkasber » Sat Oct 04, 2008 8:45 am

Hi!

I have to add and test a new shipping method that is based on a really big zip code table (NOT US) this table is CSV format with zip codes and provinces. How can I insert this table on AC7? What is the best way? (not typing a thousand zipcodes please)

Thanks

User avatar
jmestep
AbleCommerce Angel
Posts: 8164
Joined: Sun Feb 29, 2004 8:04 pm
Location: Dayton, OH
Contact:

Re: Shipping Tables insert question

Post by jmestep » Sat Oct 04, 2008 1:38 pm

It's possible that you can copy the data in from an excel spreadsheet if you can access the database directly. Your excel file would have to match the layout of the table ac_TaxRules, except for the TaxRuleId field, which is incremented automatically.
Judy Estep
Web Developer
jestep@web2market.com
http://www.web2market.com
708-653-3100 x209
New search report plugin for business intelligence:
http://www.web2market.com/Search-Report ... -P154.aspx

Post Reply