[ic] Correcting the products database

Gert van der Spoel gert at 3edge.com
Fri Jan 15 19:38:01 UTC 2016


> -----Original Message-----
> From: interchange-users-bounces at icdevgroup.org [mailto:interchange-
> users-bounces at icdevgroup.org] On Behalf Of Stefan Hornburg (Racke)
> Sent: Friday, January 15, 2016 21:23
> To: interchange-users at icdevgroup.org
> Subject: Re: [ic] Correcting the products database
> 
> 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 approach.
> 

Right be very sure that you want to do this .. It will remove everything
from the products table and rewrite it with what's in the products.txt ... 

> Regards
>          Racke
> 
> > #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?

I'd check to be sure that all css and js files are loading properly, just in
case anything is missing in that area. 

> >
> >
> > 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.
> 
> 
> _______________________________________________
> interchange-users mailing list
> interchange-users at icdevgroup.org
> http://www.icdevgroup.org/mailman/listinfo/interchange-users




More information about the interchange-users mailing list