I used chatgpt to create this SQL based on the prompt “can you create a SQL create table based on this data“
I additionally copied and pasted the header and the first 4 rows of data in the prompt.
CREATE TABLE products (
handle VARCHAR(255) NOT NULL PRIMARY KEY,
title VARCHAR(255) NOT NULL,
body_html TEXT,
vendor VARCHAR(255),
product_category VARCHAR(255),
type VARCHAR(255),
tags TEXT,
published BOOLEAN DEFAULT FALSE,
option1_name VARCHAR(255),
option1_value VARCHAR(255),
option1_linked_to VARCHAR(255),
option2_name VARCHAR(255),
option2_value VARCHAR(255),
option2_linked_to VARCHAR(255),
option3_name VARCHAR(255),
option3_value VARCHAR(255),
option3_linked_to VARCHAR(255),
variant_sku VARCHAR(255),
variant_grams DOUBLE(8, 2),
variant_inventory_tracker VARCHAR(255),
variant_inventory_qty INT,
variant_inventory_policy VARCHAR(255),
variant_fulfillment_service VARCHAR(255),
variant_price DECIMAL(10, 2),
variant_compare_at_price DECIMAL(10, 2),
variant_requires_shipping BOOLEAN DEFAULT FALSE,
variant_taxable BOOLEAN DEFAULT FALSE,
variant_barcode VARCHAR(255),
image_src TEXT,
image_position INT,
image_alt_text VARCHAR(255),
gift_card BOOLEAN DEFAULT FALSE,
seo_title VARCHAR(255),
seo_description TEXT,
google_product_category VARCHAR(255),
google_gender VARCHAR(255),
google_age_group VARCHAR(255),
google_mpn VARCHAR(255),
google_condition VARCHAR(255),
google_custom_product BOOLEAN DEFAULT FALSE,
google_custom_label_0 VARCHAR(255),
google_custom_label_1 VARCHAR(255),
google_custom_label_2 VARCHAR(255),
google_custom_label_3 VARCHAR(255),
google_custom_label_4 VARCHAR(255),
other_information TEXT,
product_quality TEXT,
supplier_id VARCHAR(255),
color VARCHAR(255),
complementary_products TEXT,
related_products TEXT,
related_products_settings VARCHAR(255),
variant_image TEXT,
variant_weight_unit VARCHAR(10),
variant_tax_code VARCHAR(255),
cost_per_item DECIMAL(10, 2),
included_united_kingdom BOOLEAN DEFAULT FALSE,
price_united_kingdom DECIMAL(10, 2),
compare_at_price_united_kingdom DECIMAL(10, 2),
included_european_union BOOLEAN DEFAULT FALSE,
price_european_union DECIMAL(10, 2),
compare_at_price_european_union DECIMAL(10, 2),
included_international BOOLEAN DEFAULT FALSE,
price_international DECIMAL(10, 2),
compare_at_price_international DECIMAL(10, 2),
status VARCHAR(255)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;