Jewelry store Web based inventory system - repost

Jewelry store inventory system.

1) Automatically generate new inventory #'s.

2) Be web based, password protected accessed from our website.

3) Be accessible from our smartphones.

4) Interface with label printer to print out stone/ring info and bar code to be placed on baggie.

5) Interface with smartphones to read bar codes and transmit the data to the web based system.

6) Interface with smartphones to allow phones to take pictures and upload to the web based inventory system.

7) Organize stones, mountings and finished jewelry to be searchable by the following metrics: Cost, location, vendor purchased from, date acquired, Type, color, weight,shape,origin,treatment, needing repair or re cutting, additional certification and clarity. Show status and track stones that are paid for but have not yet arrived at our location. Allow tacking numbers to be uploaded for incoming shipments (returns and incoming stone, mountings and finished jewelry)

8) Use drop down feature to reduce input time.

9) Able to download data to excel.

10) Will automatically upload the finished photos from the server once photo department uploads them for posting on the website.

11) Scan barcode in and scan out for multiple locations: (listed as a stone, mounting or finished item) multiple locations, setter,

repair, shipping department etc. ...Date Sold!! Sold recently or sold (more than 30 days indicating it will not be returned) etc.

12) Inventory searchable from within any location.

13) Data of finished jewelry item to automatically populate fields in the Certification Mapping Spreadsheet used when an item is certified.

14 )Comprehensive vendor list showing Name, Address, Phone number, email, website etc. Type of stone/mountings purchased,

all items purchased, outstanding invoices by date opened and date due, Price per carat per stone category (including color and clarity!!!)

and cross reference against other sellers to determine who is giving us the best prices for each type of stone/mounting. Show total amounts

outstanding to vendors and sync with google calendar to coordinate payments through bill pay.

15) Comprehensive dashboard showing total finished inventory by category, all stone by types and dollar amount and all mountings,

damaged items, returns etc. charts and stone inventory, total stone at each location, Allowing for overall inventory

information to be available at a glance. Showing total sold per category.

16) Show all items waiting for payment from buyers showing date purchased, where purchased, amount owed, details of transaction

(making 3 payments etc.). Rate buyers by how often they buy, dollar amount spent, how often they return items/complain, Identify problem

customers based on multiple returns.

17) Show details of our buyers, amount spent with us, amount spent in the last 12 months etc, where they live, male or female,

type of jewelry they are buying, their contact information and specific jewelry they are looking for. A notification function

when a new item fitting the description of something a buyer is looking for comes into our inventory.

18) we need to know which items are currently being offered for sale and where (ie online, to a cusomer directly), which items are being

held for a customer and why.

19) We need to know which stones are on hold waiting for incoming mountings (design phase) and what type of item it is to become

(ie ring, pendant, earring or necklace).

20) Chart showing price per carat increases and decreases from vendors.

21) Chart showing increased sales and decreased sales in each category of finished jewelry.

22) Chart showing increased and decreased profitability based on category of finished jewelry

23) Reminder when inventory drops below a certain level in each category of stone and finished jewelry.

We want it to be fast and simple to use.

Skills: Engineering, PHP, Software Architecture, Software Testing

See more: web based inventory, web based inventory system, web print website sale, web design vendors, web design payments price, web design phones, web design color number, web design color codes, web design certification, web codes design, web based design, address buy online, types data graphs, outstanding web design, best color web design, scan code online, sale store online, prices web design, price design label, price label design, php certification cost, online web design download, online print calendar, online price label design, online payments web design

About the Employer:
( 0 reviews ) Newport Coast, United States

Project ID: #4658343

12 freelancers are bidding on average $513 for this job


Hi! Our PHP Experts can do this project for you professionally. Please check PMB for details.

$515 USD in 6 days
(154 Reviews)

Hi ready to start Thanks

$515 USD in 23 days
(174 Reviews)

Hi. We are a 10 year old professional IT software company. We would like to work on this project. Thanks.

$368 USD in 7 days
(3 Reviews)

Kia ora! are a NZ based web and software design company who have seen you here on the freelance market and are really excited about working with you and treating you to the full service, professional ex More

$515 USD in 21 days
(5 Reviews)

I'm ready....

$277 USD in 12 days
(18 Reviews)

Read your details and interested to work, thanks.

$555 USD in 30 days
(31 Reviews)

Ready to start now..Many thanks..

$500 USD in 15 days
(16 Reviews)

Same kind of website I built before. Please check your private message

$555 USD in 10 days
(3 Reviews)

hi sir Dolphinesoft is a professional Software Development Company providing complete IT solutions and acting as an offshore development center for overseas development firms. We are an innovative company, based in In More

$789 USD in 30 days
(1 Review)

Please check INBOX to get some exclusive offer from me.

$388 USD in 15 days
(0 Reviews)

I have worked earlier on similar kind of project..

$577 USD in 25 days
(0 Reviews)

ready to start work as soon as possible.

$600 USD in 25 days
(0 Reviews)