thanks... undecided on how I'll do this shop database... spreadsheet seems like the easiest way to input everything

don't need to do anything more with the spreadsheet.

I'll reply later when I see how well spreadsheet import to database goes.

here updated...

AutoID ID IDName

Are all complete so don't touch those ones.

Need to add the prices use the BuyPrice And Sellprice columns, (BuyPrice64, SellPrice64) are calculated based on the single item price, just delete the entry if the item is not sold.

try to make sure version 1.8 blocks are identified, I've added a 'Versions' column for it

Would be nice if crafted items got there prices from base raw materials

ie You get 4 Woodplanks from 1 Log, so the price for wood planks is Log/4  ... that way only need to adjust the log prices to change the price of wood.

Want to do that or not?

itemImage leave blank, I'll do that later

For Category  ..use  etc

Raw Materials
Processed Materials
Mineral Resources
Plants & Farming
...etc  check this link for more...  http://kraftzone.net/Adminshop.htm

Updated the spreadsheet with all the item and block image file names (column O and R) not all images can be used,
http://kraftzone.net/shop/images/   to see

This is what i got for now

This is what i got for now will keep on tomorrow

Working on it again thx miver, will post an updated version, looks like the mob spawn egg and potion images have to be made.

updated.. Only need prices from adminshop aadding, categories, version( most are 1.7 a few are 1.8 future items) and a new column I added called 'Hidden'  ie not all items are placeable or even viewable, so use 'yes' if they are hidden' otherwise 'no'

For Category  ..use 

Raw Materials
Processed Materials
Mineral Resources
Plants & Farming
...etc  check this link for more...  http://kraftzone.net/Adminshop.htm