Database for small retail business

Ditutup Disiarkan 5 tahun lepas Dibayar semasa penghantaran
Ditutup Dibayar semasa penghantaran

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.

Pentadbiran Pangkalan Data Pembangunan Pangkalan Data Pengaturcaraan Pangkalan Data

ID Projek: #18095241

Tentang projek

10 cadangan Projek jarak jauh Aktif 5 tahun lepas

10 pekerja bebas membida secara purata $281 untuk pekerjaan ini

webzin

Welcome to Webzin Infotech, Thank you for taking time to review our bid, we are ready to start the project. For more details please refer our profile,portfolio. If you have any question feel free to ask. We are Lagi

$277 NZD dalam 7 hari
(1 Ulasan)
2.4
lexsystems

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 Lagi

$30 NZD dalam 3 hari
(2 Ulasan)
1.8
abhimadankr

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

$30 NZD dalam 3 hari
(0 Ulasan)
0.0
utkarsh4dev

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 .

$133 NZD dalam 7 hari
(0 Ulasan)
0.0
Rajeshrk123

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 Lagi

$150 NZD dalam 5 hari
(0 Ulasan)
0.0
swinford

Hello, I am interested in the project you have listed, I believe I can help. Looking forward to hear more about the specifications.

$300 NZD dalam 3 hari
(0 Ulasan)
0.0
jssymm

We have over 15 years experience in ERP, inventory, SCM and integration. WooCommerce has a plug-in for downloading data in Excel. But I do not think there is a scheduler for this plug-in. If this data export is manuall Lagi

$1388 NZD dalam 15 hari
(0 Ulasan)
0.0
stefanoturchet

I can make it in Filemaker. It’s a professional program with a nice design and an easy development structure

$283 NZD dalam 15 hari
(1 Ulasan)
0.0
AndreiTudorache9

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 Lagi

$66 NZD dalam 4 hari
(0 Ulasan)
0.0