Database for small retail business
$30-250 NZD
货到付款
DATABASE DEVELOPMENT
We are a small business in Sweden offering a bed linen rental subscription service for private homes. In order to keep track of our stock and deliveries we have implemented RFID chips into our products. Upon each order every product that leaves our warehouse is scanned and the RFID number is connected to the customer. Once the customer returns the used bed linen the products are scanned again. This process allows us an overview of the logistic cycle.
The types of data we need to store:
– Customer adresses
– Customer orders including subscription dates and shipping method
– RFID data for each product
– RFID data tied to each order and customer (including date)
– RFID data for returning products (including date)
– Weight of each product
Examples of queries we need to access:
– ”Packing list” = amount of products for each upcoming order + weight + box/bags requirement
– Outstanding products for each customer + expected return date
– Outstanding products (total)
– Stock requirement (amount of products) for the upcoming 1/2/3/4 weeks
– Number of uses of each individual product (how many times it has been rented out)
– Amount of orders for each customer
– Sales statistics, total and per customer
PLEASE CONTACT ME FOR MORE INFORMATION
–––––––
CUSTOMER & ORDER DATA
Our sales platform is Woocommerce. It is possible to extract reports of customer adresses, orders and subscriptions to Excel / csv formats. Ideally we would set up an automatic extraction once a week and this data would automatically be updated in our database.
–––––––
OUTGOING ORDERS
We offer five types of bed linen products:
PC = pillow cases
S1 = sheet, single
S2 = sheet, double
D1 = duvet cover, single
D2 = duvet cover, double
We offer four types of bed linen sets:
Double Duo = 1*S2 + 2*D1 + 2*PC
Double = 1*S2 + 1*D2 + 2*PC
Mini = 1*S2 + 1*D1 + 2*PC
Single = 1*S1 + 1*D1 + 1*PC
Two additional variables are:
– Quantity of each product or bed linen set
– Number of exchanges of each bed linen set per month (1–4)
–––––––
PACKING LIST
A sample order may be:
1 Double Duo, 2 exchanges per month + 2 Single + 4 pillow cases
Our database needs to display this as a packing list made up by separate products:
10*PC + 2*S1 + 2*S2 + 6*D1
Ideally the packing list would be automatically paired with the scanned RFID data as to determine that the correct products have been packed.
The packing list also needs to display:
– total weight of the order
– do we need a box size small or large? (depending on amount of products)
– how many return bags should be included? (depending on amount of products)
–––––––
INCOMING ORDERS
When products are returned to our warehouse they will once again be scanned to determine the RFID numbers. This data needs to be automatically paired with the outgoing order and customer. (That is: without us having to locate the order manually)
–––––––
RFID SCANNING
This is the software we use to RFID scan our products:
https://drive.google.com/file/d/1aBrjGvqtVa81Ki8hjFzkGdawzCXJFNEc/view?usp=sharing
Today we need to manually copy and paste the RFID numbers from the software to Google Sheets. Ideally, there would be an automatic connection between the software and our database.
项目ID: #18095241
关于项目
有10名威客正在参与此工作的竞标,均价$281/小时
Hello. My name is Alexander. I am a young PHP and MySQL developer. My specialty is database design and programming and interacting with those through PHP. I am fluent in English and I can deliver a great product. Wh 更多
I read the job description and I can do it.I have worked on many such projects.I can work on urgent basis and for a reasonable rate..Contact me so we can discuss further
Sir/ma'am , I have good knowledge of SQL and noSQL database , and i think that i can achieve this task with efficiency and effectively .
Dear sir i am best at database development in mysql or ms sql , coming to your project , i will create an database that will satisfy your all queries , db tables will normalized , inter related with foreign keys , and 更多
Hello, I am interested in the project you have listed, I believe I can help. Looking forward to hear more about the specifications.
I can make it in Filemaker. It’s a professional program with a nice design and an easy development structure
Hello, I'm working every day with database and i'm very excited about my work. I have been working for almost 3 years in a datawarehouse department. I don't consider myself an expert, but I am an ambitious young m 更多