Database for small retail business


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



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.


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)


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)


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)


This is the software we use to RFID scan our products:

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.

Compétences : Administration de Bases de données, Développement de bases de données, Programmation de bases de données

en voir plus : dating business database leads, database small law firm, cleaning business database access 2007, shop database example, retail software for small business, retail store database example, retail shop database design, database for retail store, best database software for small business, clothing store database example, retail store database download, google business database, business database queensland, india business database excel, write short essay explaining set database small company, retail shop database, business database crawler, small php app database operation, database retail business, move exchange database small business server 2008

Concernant l'employeur :
( 35 commentaires ) faridabad, India

Nº du projet : #18095241

11 freelance font une offre moyenne de $270 pour ce travail


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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% NZD en 7 jours
(1 Évaluation)

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% NZD en 3 jours
(1 Évaluation)

Hi, How are you? I've carefully read your description and I am very interested in your project. No worries, if you give me a chance I will do my best, too., I can show you my awesome skills based on my rich experienc Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% NZD en 3 jours
(0 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% NZD en 3 jours
(0 Commentaires)

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 .

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% NZD en 7 jours
(0 Commentaires)

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% NZD en 5 jours
(0 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% NZD en 3 jours
(0 Commentaires)

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% NZD en 15 jours
(0 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% NZD en 15 jours
(0 Commentaires)
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% NZD en 3 jours
(0 Commentaires)

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% NZD en 4 jours
(0 Commentaires)