[ic] Quantity Price Break
kerry at basicq.com
Sun Nov 30 17:22:23 UTC 2008
> Quoting kerry (kerry at basicq.com):
>> > 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.
>> >> apply change did not make the fields available in the pricing.txt
>> > If you are making the changes in MySql, then you will need to export
>> > 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
>> >> the errors mentioned earlier. I also tried adding the definitions to
>> >> 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
>> > 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?
> "From a remote server"? What precisely do you mean by that?
Interchange is on a machine I do not have root control over. I do have ssh
access and can manage my web site.
> You can add them simply by importing a new text file with those columns.
When I try to import the pricing.txt file, I get errors on the fields I
add. Errors say the fields are not defined.
> That is just one way. If you upload a new dbconf/mysql/pricing.mysql
> file with the column types, you can set those that way. The default
> type will actually work OK.
>> I did change catalog.cfg and applied
>> change, but this did not change what was in the mysql database.
> It is pretty hard to develop on Interchange without SSH access.
> Another way to add a column is with the Direct SQL feature in
> the database editor area:
I think I have been in there, but I will recheck.
> alter table pricing add column q12 varchar(16)
> Make sure you "Apply Changes".
> Mike Heins
> Perusion -- Expert Interchange Consulting http://www.perusion.com/
> phone +1.765.328.4479 tollfree 800-949-1889 <mike at perusion.com>
> I don't want to get to the end of my life and find I have just
> lived the length of it. I want to have lived the width of it as
> well. -- Diane Ackerman
> interchange-users mailing list
> interchange-users at icdevgroup.org
More information about the interchange-users