Database for online store: Bakeware

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: 2165+ штук
- 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.