Online Store Database: Baby Teas
Sold 0
Refunds 0
Good feedbacks 0
Bad feedbacks 0
Base for an online store or catalog.
Before buying a base, carefully read the description. Refunds after receiving the goods is not possible, if in doubt, contact us to clarify the details.
The base contains:
- commodity items with characteristics: 55 pieces
- Contains reviews on some products (they are few, but they are from real buyers)
- Contains a photo for almost all products (~ 95-99%), some photos (~ 3-5%) have a watermark (gray, slightly noticeable)
-
In the archive you will receive:
- Dump 4 MySQL tables (Product catalog \ Features \ Images \ Reviews)
- List of URLs to images (file URL list you can download using wget: wget -i link_list_file.txt)
-
Access to updates is discussed separately in an individual conversation.
For add. board (discussed separately) we can upload the image to your or our DigitalOcean \ Amazon AWS storage.
For add. board (discussed separately) we will upload the directory in the format and file type you need (you must have a clear description of the file format or a sample file with at least 1 heading in it).
Before buying a base, carefully read the description. Refunds after receiving the goods is not possible, if in doubt, contact us to clarify the details.
The base contains:
- commodity items with characteristics: 55 pieces
- Contains reviews on some products (they are few, but they are from real buyers)
- Contains a photo for almost all products (~ 95-99%), some photos (~ 3-5%) have a watermark (gray, slightly noticeable)
-
In the archive you will receive:
- Dump 4 MySQL tables (Product catalog \ Features \ Images \ Reviews)
- List of URLs to images (file URL list you can download using wget: wget -i link_list_file.txt)
-
Access to updates is discussed separately in an individual conversation.
For add. board (discussed separately) we can upload the image to your or our DigitalOcean \ Amazon AWS storage.
For add. board (discussed separately) we will upload the directory in the format and file type you need (you must have a clear description of the file format or a sample file with at least 1 heading in it).
We also have other thematic databases.
DB structure:
Table with goods:
uid - Unique identifier for the item
iid - Product ID
category - Category
vendor - Manufacturer
title - Title
alt_title - Alternative name (usually more complete)
description - Product Description
guid - product GUID (unique ID)
Table with photos:
part_id - product ID
image_type - Image type (in your case there will be a link, it means that the link to the file)
image_link - URL of the image (at least 1 month from the date of sale is available, in other cases it is updated separately)
imageid - image ID
imgindex - Unique image identifier
Table with characteristics:
uid - Product ID
p_name - name of the characteristic (For example: Voltage)
p_value - value of the characteristic (For example: 230V)
listname - section of characteristics (For example: General characteristics)
Table with reviews:
catalog_id - Product ID
title - review title (summary)
rating - rating from 1 to 5
content - review itself
author - author of the review (Vasya, Kolya, Fedor, etc., as an example, only Name)
date_r - date of leaving review
pros - advantages, benefits
cons - cons, disadvantages
-
Update:
The database is constantly updated - several times a week, all categories as data appears on the websites sources (marketplace).
An update is an updated MySQL Table dump file that contains additional and new data.
To load announcements without additional processing, you should keep the table structure in the same state (field names and types, unique indexes and AI fields), if the structure is changed, the update is not guaranteed and you should update the data on your own system.
DB structure:
Table with goods:
uid - Unique identifier for the item
iid - Product ID
category - Category
vendor - Manufacturer
title - Title
alt_title - Alternative name (usually more complete)
description - Product Description
guid - product GUID (unique ID)
Table with photos:
part_id - product ID
image_type - Image type (in your case there will be a link, it means that the link to the file)
image_link - URL of the image (at least 1 month from the date of sale is available, in other cases it is updated separately)
imageid - image ID
imgindex - Unique image identifier
Table with characteristics:
uid - Product ID
p_name - name of the characteristic (For example: Voltage)
p_value - value of the characteristic (For example: 230V)
listname - section of characteristics (For example: General characteristics)
Table with reviews:
catalog_id - Product ID
title - review title (summary)
rating - rating from 1 to 5
content - review itself
author - author of the review (Vasya, Kolya, Fedor, etc., as an example, only Name)
date_r - date of leaving review
pros - advantages, benefits
cons - cons, disadvantages
-
Update:
The database is constantly updated - several times a week, all categories as data appears on the websites sources (marketplace).
An update is an updated MySQL Table dump file that contains additional and new data.
To load announcements without additional processing, you should keep the table structure in the same state (field names and types, unique indexes and AI fields), if the structure is changed, the update is not guaranteed and you should update the data on your own system.