It would be nice to have a field in the items table that displayed the product's putup or Unit of Measure. i.e. roll, kg, box, carton, gross, yard, dozen etc.

Would this help, I was trying to add custom fields for other purposes (that would be upgrade proof and show or not show on the site )but the logic is the same.
 
here is what somebody posted
 
The short answer is no, the database is hard wired. You can make schema changes using regualr sql tools, but there is no way to assure they will live through a software revision.
 
Viart has an interesting (but in no way intuitive!) way to add specification to products. Rather than explaining how it works, I'' walk through an example. Lets say you are selling tires and you want the database to a width, rim diameter and speed rating.
 
Step 1. Define a Product Type
goto: Administration > Products > Products Types
click: [New Product Type]
 
Name the product 'tire'
 
Step 2: Define Specification Groups.
This step basically defines containers for individial specs. You will define a group for each grouping of specs you want to containerize when rendered on the product pages. For instance, you may have "Size" that will show size, tread width, and overall height. Then another spec group, "Tech Specs" that shows load rating, speed rating, and tread life.
 
goto: Administration > Products > Specification Groups
click: [ New Specification Group ]
Give the group a name - lets say "Tire Specs"
click: [ New Specification Group ]
Give the group a name - lets say "Tech Specs"
 
Step 3: Predefining Specifications
goto: Administration > Products > Products Types
find the product type (Type Name column), click on [Predefined Specification]. Now you should be at the page: Administration > Products > Products Types > tire > Predefined Specification. In the Group Name column, select Size, then in the field below, enter DIAMETER. If you want a selection of predefined specs, enter them in the PREDEFINED VALUES column.
 
Repeat this step for ever spec you want to enter.
 
Step 4: Add the product to your database using the admin interface. While still in the admin interface, navigate to the product category that holds the product. For the product you want to modify, click SPECIFICATION. Fill in the blanks and click UPDATE.
 
------
Step 3 isn't mandatory, but if you have a lot of similar products it's worthwhile.
 
Now look at the user side of your site, you should see the specs grouped together as we just defined them.
 
------
The way Viart deployed this is quite clever. It's not documented well, nor is it intuitive -- but once you figure it out it's workable.
 
Suggestion: we record these things in using the Manual feature in the admin area. Suggest you do the same as some of these things are hard to remember, so the next time you might be just as stumped as you are now.
 
Hope this helps

Thanks freezer,
 
ps. I think it I wrote the above

ha ha glad I didn't try and pass as my own work.
 
I have contacted viart with the suggestion of having th ability to add extra fields at product level. e.g to the items table.
 
They quoted unlimited fields of any type e.g numerical, text, currency etc
 
for $600
 
I posted this in the feature requests area along with a purchase order system I had requested but nobody replied.
 
I am sure many would find this useful, hopefully viart will add in the future

Didn't say but these fields could be added easily via the admin area and the fields could have a name of your choice
 
I in particular want to store re-order levels for stock, barcode numbers for labelling and much more, critical stock level field to alert when getting low bla bla bla
 
You could maybe ask Viart the same and see if you have any luck in the forums
 
good luck!!

freezer, did you find anybody to go in with you on this feature?

Hi,
 
No luck I'm afraid my original post is below
 
http://www.viart.com/stock_control_to_include_purchase_ordering.html
 
or if link is blocked type stock control into forum search