[ic] Quantity Price Break

[kerry]

> 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
>>> mysql
>>> database
>>>
>> 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.
>
> If you want to make the changes in pricing.mysql, and go from text to
> database, then make changes in
>
> dbconf/mysql/pricing.mysql,
>
> AND in
>
> products/pricing.txt
>
> then remove
>
> products/.pricing.sql

I do not seem to have access to this file as I am working remote. I am
using 5.6.1
Is there a way to add the extra q & w price breaks to the files I have
access to from a remote server? I did change catalog.cfg and applied
change, but this did not change what was in the mysql database.

Still stuck,

Kerry

>
> 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
> versions.
>
>>  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:
>>> CommonAdjust
>>> pricing:q1,q2,q3,q4,q5,q6,q10,q12,q15,q24,q25,q36,q48,q50,q72,q100,q144,q250,
>>> ;:sale_price, ;:price, ;$, :related, ==:options
>>> PriceField     0
>>>
>>> I remember some issues with this long list of discounts, make sure it
>>> is
>>> all
>>> on one line.
>>>
>>> Steve
>>>
>>>
>>> _______________________________________________
>>> interchange-users mailing list
>>> interchange-users at icdevgroup.org
>>> http://www.icdevgroup.org/mailman/listinfo/interchange-users
>>>
>>>
>>
>>
>> _______________________________________________
>> interchange-users mailing list
>> interchange-users at icdevgroup.org
>> http://www.icdevgroup.org/mailman/listinfo/interchange-users
>>
>> .
>>
>>
>
>
> --
> Greg Hanson
> Interchange Consulting
> Perusion
> 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
> http://www.icdevgroup.org/mailman/listinfo/interchange-users
>