Database, Layout Help Required

[murderking88]

Hello,


I just have a few questions if anyone could help answer them,

1) Does anyone know whether it is possible to update prices of components,permutations, and customer groups prices via the db,
i know and have updated the retail price of the products, but can;t seem to locate where the prices of the rest is located, i am sure i am just unable to locate them

2) anyone know how, rather where the YourPricePrefix variable is located, what i need to do for my client is to add a additional pricing. i have done it for retail customers, but can;t seem to locate for registered users,

what i need to do is like:

Price per cm: $XXX (which is settled by the normal price)
Price per metre : $XXX (which i have done, but just need to find a way to display for registered users, i can do it for retail grp)

Thanks to the ppl who answer and view this in advance..


3)The cart keeps showing extra info, i figured out its the ref no and quantity, i can rmv the ref, but the qty, i have no clue, why it repeats like that.. help pls.(view attachment)


Cheers,
murderking88

[TraceyG]

Hi,

1) Does anyone know whether it is possible to update prices of components,permutations, and customer groups prices via the db,

The components and permutations are kept in the 'ProductProperties' table, where 'nType' is:

5 - Component
6 - Attribute
7 - Choice
8 - Permutation

Customer groups are held in the 'Price Schedules' table.

We don't recommend updating straight to the database but if you want to do it this way then always take a backup of the database before making any changes.

2) anyone know how, rather where the YourPricePrefix variable is located,

The prices for the logged in customers is kept in the 'OnlinePriceLayout' (Design | Library | Layouts | Prices for Customer Accounts | whichever layout your site uses)

3)The cart keeps showing extra info, i figured out its the ref no and quantity, i can rmv the ref, but the qty, i have no clue, why it repeats like that

It repeats because it is showing the quantity for your choice too. To remove it take a look at this kb article.