Data extraction

Data architecture needed to start using Pleasepoint artificial intelligence. Here you will get all the entities and attributes you need to export from your eCommerce.

1. Data schema

There are 5 entities to export data into 5 distinct files:

• Customers: All customers information table.

• Products: All products information table.

• Shops: All shops information table. Only required if there is more than one shop (online/offline).

• Orders: All orders information table. Use customer and shop reference id.

• Line orders: All the line orders information table. Use order and product reference id.

2. Customer's table

Sample customer data to be extracted. The export file must be a Utf8 CSV file.

These are the required fields:

• reference_id (Mandatory, Primary key, Text): Customer unique identifier for the eCommerce. Used to reference the customer's orders.

• name (Optional, Text): Customer name. Can be anonymized.

• surname (Optional, Text): Customer surname. Can be anonymized.

• email (Mandatory, Unique, Email): Customer email. Must be unique.

• mail_status (Mandatory, Text): Acceptance or not of the GDPR option clauses (reception of commercial information). Value subscribed for true and unsubscribed for false. If not available, it will be considered negative option by default.

• gender (Optional, Text): Customer gender.

• birth_date (Optional, Date): Customer birth date.

• age (Optional, Number): Customer age.

• city (Optional, Text): Customer city.

• Country (Optional, Text): Customer country.

• city (Optional, Text): Customer city.

• open_rate (Optional, Number): Customer open rate form CRM campaigns.

• click_rate (Optional, Number): Customer click rate form CRM campaigns.

You are able to add any attribute for your customers. Only create a new column in the CSV file and add de values for all the users (Please insert a default value when is empty). 

3. Product's table

Sample product data to be extracted. The export file must be a Utf8 CSV file.

These are the required fields:

• reference_id (Mandatory, Primary key, Text): Product unique identifier for the eCommerce. Used to reference the product in the line order.

• name (Mandatory, Text): Product name.

• price (Mandatory, Number): Product price.

• description (Mandatory, Text): Product description.

• category_n1 (Mandatory, Text): First category level.

• category_n2 (Optional, Text): Second category level.

• category_n3 (Optional, Text): Third category level.

• category_nX (Optional, Text): X category level.

• total_stock (Mandatory, Number): The total stock for the product.

• url (Mandatory, Text): Product page link.

• image_url (Mandatory, Text): Product image link to product page.

• product_catalog_id (Mandatory, Text): Product identifier for product catalog.

You are able to add any attribute for your products. Only create a new column in the CSV file and add de values for all the products (Please insert a default value when is empty). 

See the image for distinct attribute examples.

4. Shop's table

Sample shop data to be extracted. Only required if you want to include offline purchases. The export file must be a Utf8 CSV file.

These are the required fields:

• reference_id (Mandatory, Primary key, Text): Shop unique identifier for the eCommerce. Used to reference the shop in the order.

• name (Mandatory, Text): Shop name.

• description (Optional, Text): Shop name.

• type (Optional, Text): Shop type.

• location (Optional, Text): Shop location.

• location_type (Optional, Text): Shop location type.

• city (Optional, Text): Shop city.

• country (Optional, Text): Shop country.

You are able to add any attribute for your shops. Only create a new column in the CSV file and add de values for all the shops (Please insert a default value when is empty). 

See the image for distinct attribute examples.

5. Order's table

Sample order data to be extracted. For one-to-one product recommendation is required at least 1-year of data. All orders must include a user reference id to identify the customer. The export file must be a Utf8 CSV file.

These are the required fields:

• reference_id (Mandatory, Primary key, Text): Order unique identifier for the eCommerce. Used to reference the line orders.

• reference_date (Mandatory, Date): The order date.

• user_reference_id (Mandatory, Foreign key, Text): The user reference id. This id identifies a customer.

• shop_reference_id (Mandatory, Foreign key, Text): The shop reference id. This id identifies a shop.

• total_amount (Mandatory, Number): Order total amount.

• total_discount (Optional, Number): Order total discount value.

• discount_code (Optional, Text): The discount code.

• discount_type (Optional, Text): The discount type.

• channel (Mandatory, Text): The order channel.

You are able to add any attribute for your orders. Only create a new column in the CSV file and add de values for all the orders (Please insert a default value when is empty). 

See the image for distinct attribute examples.

6. Line order's table

Sample line order data to be extracted. For one-to-one product recommendation is required at least 1-year of data. All line orders must include a order reference id and a product reference id. The export file must be a Utf8 CSV file.

These are the required fields:

• ticket_reference_id (Mandatory, Foreign key, Text): The order reference id. This id identifies an order.

• product_reference_id (Mandatory, Foreign key, Text): The product reference id. This id identifies a product.

• quantity (Mandatory, Number): The number of items with this product id.

• price (Mandatory, Number): Unitary price. To get the real price: quantity x price.

• colour (Optional, Text): The product color.

• size (Optional, Text): The product size.

• variaton_id (Optional, Number): Product variation id.

• variation_name (Optional, Number): Product variation name.

• discount_value (Optional, Number): Product discount value.

• discount_name (Optional, Number): Product discount name.

You are able to add any attribute for your line orders. Only create a new column in the CSV file and add de values for all the line orders (Please insert a default value when is empty). 

See the image for distinct attribute examples.