[ic] Correcting the products database

Stefan Hornburg (Racke) racke at linuxia.de
Fri Jan 15 19:23:06 UTC 2016

On 01/15/2016 07:43 PM, David Etheredge wrote:
> Using IC 5.10.0 and Strap
> #1) I would like to be able to load products from the products.txt file rather than use the items editor. 
> This allows me to make changes using a spreadsheet. How can I tell interchange to read the products.txt file  and if there are changes,
> dump the database file and rebuild from products.txt? The import function only adds new products and the delete items function fails.

There is either a products.sql or .products.sql in the same directory as products.txt. If you delete this *.sql file,
it will rebuild the products table from the products.txt when you restart Interchange or reconfig the catalog.

Note: I always flag my Interchange databases with "NoImport" to prevent this scenario, as I don't like this


> #2) Anyone currently have a working FedEx shipping set up instead of UPS?
> #3 ) Also, is there a way to calculate in insurance costs into the shipping. We often have orders of over $1000 US and insurance gets EXPENSIVE, especially for the postal service.
> #4) Any hints for multiple pay paths? I want to use PayPal Express, Authorize.net, and online checking from Authorize.net. Currently Using a kludged access to PayPal.
> #5) I see that the pricing tables for USPS Priority and EMS services are very out of date. Could easily go broke using them. Anyone have newer tables set up?
> #6) In Admin, the layout is missing or something because the pages are mostly scrambled text. Any suggestions on where to look for that?
> As always. TIA!
> David
> _______________________________________________
> interchange-users mailing list
> interchange-users at icdevgroup.org
> http://www.icdevgroup.org/mailman/listinfo/interchange-users

Perl and Dancer Development

Visit our Perl::Dancer conference 2015.
More information on https://www.perl.dance.

More information about the interchange-users mailing list