[ic] Quantity Price Break
kerry at basicq.com
Wed Dec 3 20:49:07 UTC 2008
> kerry wrote:
>>>>> You can add as many as you need - what database are you using?
>>>> Using mysql
>>> It has been awhile since I did this, but I just add new fields to my
>> This looks like the catalog.cfg which is what I originally changed. But,
>> apply change did not make the fields available in the pricing.txt table.
> If you are making the changes in MySql, then you will need to export the
> table from IC in order to make the changes visible in pricing.txt.
>> Plus if I add it to the pricing table and try to import the table, I get
>> the errors mentioned earlier. I also tried adding the definitions to the
>> pricing.mysql file.
> If you make the changes in Mysql, then you do not *have* to change
> pricing.mysql. You just need to make the changes in Mysql, then restart
> or apply changes (either will work), then use Export from IC in tables
> area. That will get you from database to text and "make the fields
> available" in pricing.txt.
Just wanted to report back that the suggestion below seems to do the
trick. I tried with a few fields with success. Was not sure how to delete
the .pricing.sql file, but searching the products directory pulled it up
so that I could delete. apply changes also worked.
Thanks for your help
> If you want to make the changes in pricing.mysql, and go from text to
> database, then make changes in
> AND in
> then remove
> and restart (either restart or apply changes will work). That will
> rebuild the table in Mysql from the text file.
> All this is in 5.6.1
> I am not sure if both apply changes or restart will work in earlier
>> I am wondering if I need to get my host to restart
>> interchange manually?
>> , and restart, or maybe just apply changes.
>>> here is my definition:
>>> ;:sale_price, ;:price, ;$, :related, ==:options
>>> PriceField 0
>>> I remember some issues with this long list of discounts, make sure it
>>> on one line.
>>> interchange-users mailing list
>>> interchange-users at icdevgroup.org
>> interchange-users mailing list
>> interchange-users at icdevgroup.org
> Greg Hanson
> Interchange Consulting
> 1506 E Gilbert Ave
> Coeur d'Alene, ID 83815
> Email greg at perusion.com
> Phone 208-667-2442
> Toll Free 800-949-1889
> Fax 775-256-2231
> Web http://www.perusion.com
> Nothing is fool proof to a sufficiently equipped fool
> interchange-users mailing list
> interchange-users at icdevgroup.org
More information about the interchange-users