[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
approach.
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?
>
>
> 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