You are here:  » in need of 2 Price fields


in need of 2 Price fields

Submitted by SWS on Mon, 2006-09-04 16:48 in

Hello,
I am working with deals, so we import regular price and saleprice
like: Price was: 89.00 Price now: 69.00 Your saving is ...%

So I was adding a field named SalePrice to the files,
working fine and also importing and adding to the DB.

Now, the problem is that the new field isnt showed on
first page as rebate, it is showing the original price, of course it does.

I managed to rewrite script to show the proper info on the product page.

Now, trying being smart I switched around the fields use Price for my discounted price
and my SalePrice with the original price, which, of course again shows a price of 0.00,
if there is no off or special price.

So, I like to know, if there is any way to work around, better said where to place a scripting,
that either the first option works. Price= Price SalePrice=SalePrice
and show the discounted price, if no discount show the original price,

or second version and on upload if price = 0.00 Price=Saleprice.

I hope it isnt too much confusing, but as I said,
need to work with 2 Prices, but there is not always a SALEPRICE.

Thanks a lot
Stefan

Submitted by SWS on Mon, 2006-09-04 17:04

Oh one more thing ! I am trying to add an extra field next to Merchant field on page http://..../admin/feeds_register_step2.php
where I can place manually an ID so I can call some offers from my main site connected to this merchant, and to be added to the feeds table. thanks for your help. have a nice evening
Stefan

Submitted by SWS on Tue, 2006-09-05 11:29

OK I fixed my first problem in admin.php

......

if ($record[$admin_importFeed["field_price"]]<"1"){
    $record[$admin_importFeed["field_price"]] = tapestry_decimalise($record[$admin_importFeed["field_saleprice"]]);
    }
    $record[$admin_importFeed["field_saleprice"]] = tapestry_decimalise($record[$admin_importFeed["field_saleprice"]]);

.......

Submitted by support on Tue, 2006-09-05 13:06

Hi,

Regarding your requirement for an ID field to reference your other information, remember that merchant name must be unique within Price Tapestry, so is it possible for you to use merchant name as the ID?

It can be added to the database, but will require a lot of modifications. The mechant ID field must be added to the feeds and products table. A new form field will be needed in feeds_register_step2.php, and the merchant ID added to the admin_register() function in includes/admin.php. Then, within the import process the merchant ID must be written into the products table for every product.

Hope this helps,

Cheers,
David.