[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
RE: Script to modify values in database
****** message to minivend-users from "Thompson-Jordan" <Thompson-Jordan@mindspring.com> ******
Seems to me like all you need to do is upload a new pricing.asc file twice
a day with the price of metals in it and Minivend will take care of the
rest automatically. Of course you will need to set up your pricing scheme
correctly.
Christopher Thompson
> -----Original Message-----
> From: owner-minivend-users@minivend.com
> [mailto:owner-minivend-users@minivend.com]On Behalf Of Ezra Gilbert
> Sent: Tuesday, April 20, 1999 9:58 PM
> To: minivend-users@minivend.com
> Subject: Re: Script to modify values in database
>
>
> ****** message to minivend-users from Ezra Gilbert
> <EGilbert@CYBERNEX.NET> ******
>
> The problem is I need actually change the value of each item in
> my database, for instance say this is my products
> database:
> products.asc
> code title weight price
> 01 gold ring 13
> (13*value_of_gold) <---- I know i can't put that in a
> 02 gold necklace 22 (22*value_of_gold)
> <---- database for the price field,
> 03 gold pendant 17 (17*value_of_gold)
> <---- but thats essentialy what i
> ...
> <---- need
>
>
> To do what you're saying I'd essentially need a "PriceMultiply"
> variable set to current value of gold say ... then
> i'd set my price field in the database to the weight of the
> item. So every price _would_ be the
> weight*the_current_value_of_gold.
>
> I know it be possible to create a "PriceMultiply" variable in
> the cfg file but how would I go about getting it to
> modify the price of an item?
>
>
> This method seems to have some promise but I can see I will run
> into alot of bumps if I do it this way (different
> metals have different values so I'd have to split each metal up
> into its own catalog ... ) If I could write a
> script that would physically change the price fields that would
> be the ideal ...
>
> Thanks for the info Mike,
> - Ezra Gilbert
>
> "Webmaster of Infothai CM Co., Ltd." wrote:
>
> > ****** message to minivend-users from "Webmaster of
> Infothai CM Co., Ltd." <webmaster@infothai.com> ******
> >
> > I did something similar with exchange rates. I used the
> "#include" functionality
> > in the catalog configuration file to incorporate the contents
> of the file. The
> > file itself contained the exchange rate defined as a Minivend
> localization
> > paramter, e.g.:
> >
> > Locale en_TH PriceDivide 36.7979
> >
> > You could do something similar, or simply define your own variable.
> >
> > Whenever the file is updated, the affected catalog(s) must be
> restarted.
> > Perl can do this by calling the appropriate catalog restart scripts.
> >
> > Regards,
> >
> > Mike
> >
> > On Tue, 20 Apr 1999 21:21:32 -0400, Ezra Gilbert wrote:
> >
> > >****** message to minivend-users from Ezra Gilbert
> <EGilbert@CYBERNEX.NET> ******
> > >
> > >I am working on a jewelry site where the prices are to be
> based on the current exchange
> > >rates of gold & silver. These prices are changed twice a
> day. Basically, the price of
> > >an item is it's weight(a field in the products database)
> times the current value of
> > >whatever metal it is. I have the current values of the
> metals outputed to files twice a
> > >day and I was wondering if anyone had any advice on how I
> should go about modifying the
> > >database. I use tab delimineted databases.
> > >
> > >I was thinking a Perl script should do the job but I am
> still quite the novice when it
> > >comes to Perl and am not positive it can do the job. If
> anyone has ever done anything
> > >like this or can offer some advice it would be greatly appreciated.
> > >
> > >Ezra Gilbert
> > >
> > >-
> > >To unsubscribe from the list, DO NOT REPLY to this message.
> Instead, send
> > >email with 'UNSUBSCRIBE minivend-users' in the body to
> Majordomo@minivend.com.
> > >Archive of past messages:
> http://www.minivend.com/minivend/minivend-list
> > >
> >
> >
> webmaster@infothai.com
> > http://www.infothai.com
> >
> > -
> > To unsubscribe from the list, DO NOT REPLY to this message.
> Instead, send
> > email with 'UNSUBSCRIBE minivend-users' in the body to
> Majordomo@minivend.com.
> > Archive of past messages:
> http://www.minivend.com/minivend/minivend-list
>
> -
> To
> unsubscribe from the list, DO NOT REPLY to this message. Instead, send
> email with 'UNSUBSCRIBE minivend-users' in the body to
> Majordomo@minivend.com.
> Archive of past messages: http://www.minivend.com/minivend/minivend-list
>
-
To unsubscribe from the list, DO NOT REPLY to this message. Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list
