/* ------------------------------------------------------------------ */
/*  Product CSV Import/Export - backend labels (consolidated)          */
/*  Single fresh-install script merging all 2026-06-10 label updates. */
/* ------------------------------------------------------------------ */

INSERT INTO `fields` VALUES (NULL, 'import_btn', 'backend', 'Products / Import button', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjBaseField', '::LOCALE::', 'title', 'Import', 'script');

INSERT INTO `fields` VALUES (NULL, 'import_title', 'backend', 'Product Import / Title', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjBaseField', '::LOCALE::', 'title', 'Import Products', 'script');

INSERT INTO `fields` VALUES (NULL, 'import_desc', 'backend', 'Product Import / Description', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjBaseField', '::LOCALE::', 'title', 'Upload a CSV file to create or update products. Each row is validated; invalid rows are skipped and listed below.', 'script');

INSERT INTO `fields` VALUES (NULL, 'import_failed', 'backend', 'Product Import / Failed', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjBaseField', '::LOCALE::', 'title', 'Import failed.', 'script');

INSERT INTO `fields` VALUES (NULL, 'import_finished', 'backend', 'Product Import / Finished', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjBaseField', '::LOCALE::', 'title', 'Import finished.', 'script');

INSERT INTO `fields` VALUES (NULL, 'import_processed', 'backend', 'Product Import / Processed', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjBaseField', '::LOCALE::', 'title', 'row(s) processed', 'script');

INSERT INTO `fields` VALUES (NULL, 'import_created', 'backend', 'Product Import / Created', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjBaseField', '::LOCALE::', 'title', 'created', 'script');

INSERT INTO `fields` VALUES (NULL, 'import_updated', 'backend', 'Product Import / Updated', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjBaseField', '::LOCALE::', 'title', 'updated', 'script');

INSERT INTO `fields` VALUES (NULL, 'import_skipped', 'backend', 'Product Import / Skipped', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjBaseField', '::LOCALE::', 'title', 'skipped (errors)', 'script');

INSERT INTO `fields` VALUES (NULL, 'import_col_row', 'backend', 'Product Import / Column Row', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjBaseField', '::LOCALE::', 'title', 'Row', 'script');

INSERT INTO `fields` VALUES (NULL, 'import_col_sku', 'backend', 'Product Import / Column SKU', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjBaseField', '::LOCALE::', 'title', 'SKU', 'script');

INSERT INTO `fields` VALUES (NULL, 'import_col_product', 'backend', 'Product Import / Column Product', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjBaseField', '::LOCALE::', 'title', 'Product', 'script');

INSERT INTO `fields` VALUES (NULL, 'import_col_result', 'backend', 'Product Import / Column Result', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjBaseField', '::LOCALE::', 'title', 'Result', 'script');

INSERT INTO `fields` VALUES (NULL, 'import_col_details', 'backend', 'Product Import / Column Details', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjBaseField', '::LOCALE::', 'title', 'Details', 'script');

INSERT INTO `fields` VALUES (NULL, 'import_state_created', 'backend', 'Product Import / State Created', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjBaseField', '::LOCALE::', 'title', 'Created', 'script');

INSERT INTO `fields` VALUES (NULL, 'import_state_updated', 'backend', 'Product Import / State Updated', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjBaseField', '::LOCALE::', 'title', 'Updated', 'script');

INSERT INTO `fields` VALUES (NULL, 'import_state_skipped', 'backend', 'Product Import / State Skipped', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjBaseField', '::LOCALE::', 'title', 'Skipped', 'script');

INSERT INTO `fields` VALUES (NULL, 'import_back', 'backend', 'Product Import / Back to products', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjBaseField', '::LOCALE::', 'title', 'Back to products', 'script');

INSERT INTO `fields` VALUES (NULL, 'import_file_label', 'backend', 'Product Import / CSV file label', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjBaseField', '::LOCALE::', 'title', 'CSV file', 'script');

INSERT INTO `fields` VALUES (NULL, 'import_btn_upload', 'backend', 'Product Import / Upload button', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjBaseField', '::LOCALE::', 'title', 'Upload & import', 'script');

INSERT INTO `fields` VALUES (NULL, 'import_btn_cancel', 'backend', 'Product Import / Cancel button', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjBaseField', '::LOCALE::', 'title', 'Cancel', 'script');

INSERT INTO `fields` VALUES (NULL, 'import_format_title', 'backend', 'Product Import / CSV format title', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjBaseField', '::LOCALE::', 'title', 'CSV format', 'script');

INSERT INTO `fields` VALUES (NULL, 'import_format_intro', 'backend', 'Product Import / CSV format intro', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjBaseField', '::LOCALE::', 'title', 'The importer reads the same columns the export produces. The header row is required (column order does not matter). Matching is by SKU: an existing SKU is updated, a new SKU creates a product.', 'script');

INSERT INTO `fields` VALUES (NULL, 'import_help_name', 'backend', 'Product Import / Help name', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjBaseField', '::LOCALE::', 'title', 'product_name - required', 'script');

INSERT INTO `fields` VALUES (NULL, 'import_help_sku', 'backend', 'Product Import / Help sku', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjBaseField', '::LOCALE::', 'title', 'sku - required and unique. Matching key: an existing SKU updates that product, a new SKU creates one. The same SKU on several rows is one product - each extra row adds a stock combination (variant).', 'script');

INSERT INTO `fields` VALUES (NULL, 'import_help_status', 'backend', 'Product Import / Help status', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjBaseField', '::LOCALE::', 'title', 'status - Available or Hidden (also accepts active/inactive or 1/2). Blank defaults to Available.', 'script');

INSERT INTO `fields` VALUES (NULL, 'import_help_categories', 'backend', 'Product Import / Help categories', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjBaseField', '::LOCALE::', 'title', 'categories - required. One or more names separated by | . Categories that do not exist are created automatically.', 'script');

INSERT INTO `fields` VALUES (NULL, 'import_help_flags', 'backend', 'Product Import / Help flags', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjBaseField', '::LOCALE::', 'title', 'is_featured, is_digital - Yes / No', 'script');

INSERT INTO `fields` VALUES (NULL, 'import_help_desc', 'backend', 'Product Import / Help descriptions', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjBaseField', '::LOCALE::', 'title', 'short_description - required (plain text). full_description - optional (plain text, any HTML is removed).', 'script');

INSERT INTO `fields` VALUES (NULL, 'import_help_price', 'backend', 'Product Import / Help price', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjBaseField', '::LOCALE::', 'title', 'price - a number, e.g. 19.99. in_stock - a whole number. Both apply to every variant of the product.', 'script');

INSERT INTO `fields` VALUES (NULL, 'import_help_extras', 'backend', 'Product Import / Help extras', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjBaseField', '::LOCALE::', 'title', 'extras - add-ons. Single: Gift Wrap (5.00). Choice list: Engraving: Initials (3.00), Full Name (6.00). Separate several extras with | .', 'script');

INSERT INTO `fields` VALUES (NULL, 'import_help_attrs', 'backend', 'Product Import / Help attributes', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjBaseField', '::LOCALE::', 'title', 'attributes - product options shaped like Size: S, M, L | Color: Red, Blue (groups separated by | , values by commas). A single row with several values creates every combination. To control the exact variants - each with its own qty and price - put one combination per row (e.g. Size: S | Color: Red) and repeat the same SKU on each row; this is exactly how export writes them.', 'script');

INSERT INTO `fields` VALUES (NULL, 'import_detail_variant_added', 'backend', 'Product Import / Detail variant added', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjBaseField', '::LOCALE::', 'title', '{COUNT} stock variant(s) added.', 'script');

INSERT INTO `fields` VALUES (NULL, 'import_help_ignored', 'backend', 'Product Import / Help ignored columns', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjBaseField', '::LOCALE::', 'title', 'The id column is ignored on import (products are matched by SKU).', 'script');

INSERT INTO `fields` VALUES (NULL, 'import_err_file', 'backend', 'Product Import / Error file', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjBaseField', '::LOCALE::', 'title', 'Please choose a valid CSV file to upload.', 'script');

INSERT INTO `fields` VALUES (NULL, 'import_err_ext', 'backend', 'Product Import / Error extension', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjBaseField', '::LOCALE::', 'title', 'Only .csv files are allowed.', 'script');

INSERT INTO `fields` VALUES (NULL, 'import_err_read', 'backend', 'Product Import / Error read', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjBaseField', '::LOCALE::', 'title', 'Could not read the uploaded CSV file.', 'script');

INSERT INTO `fields` VALUES (NULL, 'import_err_empty', 'backend', 'Product Import / Error empty', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjBaseField', '::LOCALE::', 'title', 'The CSV file has a header but no data rows.', 'script');

INSERT INTO `fields` VALUES (NULL, 'import_err_name', 'backend', 'Product Import / Error name required', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjBaseField', '::LOCALE::', 'title', 'product_name is required', 'script');

INSERT INTO `fields` VALUES (NULL, 'import_err_sku', 'backend', 'Product Import / Error sku required', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjBaseField', '::LOCALE::', 'title', 'sku is required', 'script');

INSERT INTO `fields` VALUES (NULL, 'import_err_status', 'backend', 'Product Import / Error status', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjBaseField', '::LOCALE::', 'title', 'status must be ''Available'' or ''Hidden'' (got ''{VALUE}'')', 'script');

INSERT INTO `fields` VALUES (NULL, 'import_err_price', 'backend', 'Product Import / Error price', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjBaseField', '::LOCALE::', 'title', 'price must be a number (got ''{VALUE}'')', 'script');

INSERT INTO `fields` VALUES (NULL, 'import_err_stock', 'backend', 'Product Import / Error stock', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjBaseField', '::LOCALE::', 'title', 'in_stock must be a whole number (got ''{VALUE}'')', 'script');

INSERT INTO `fields` VALUES (NULL, 'import_err_insert', 'backend', 'Product Import / Error insert', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjBaseField', '::LOCALE::', 'title', 'Database insert failed (duplicate SKU?).', 'script');

INSERT INTO `fields` VALUES (NULL, 'import_help_photos', 'backend', 'Product Import / Help photos', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjBaseField', '::LOCALE::', 'title', 'photos - image URLs separated by | . Each URL must be reachable by the server; images are downloaded into the product gallery.', 'script');

INSERT INTO `fields` VALUES (NULL, 'import_help_similar', 'backend', 'Product Import / Help similar products', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjBaseField', '::LOCALE::', 'title', 'similar_products - comma-separated product names (linked when a matching product exists)', 'script');

INSERT INTO `fields` VALUES (NULL, 'import_progress_title', 'backend', 'Product Import / Progress title', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjBaseField', '::LOCALE::', 'title', 'Importing products', 'script');

INSERT INTO `fields` VALUES (NULL, 'import_progress_preparing', 'backend', 'Product Import / Progress preparing', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjBaseField', '::LOCALE::', 'title', 'Preparing import, please wait...', 'script');

INSERT INTO `fields` VALUES (NULL, 'import_progress_status', 'backend', 'Product Import / Progress status', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjBaseField', '::LOCALE::', 'title', '{processed} of {total} rows processed', 'script');

INSERT INTO `fields` VALUES (NULL, 'import_err_request', 'backend', 'Product Import / Error invalid request', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjBaseField', '::LOCALE::', 'title', 'Invalid request.', 'script');

INSERT INTO `fields` VALUES (NULL, 'import_err_access', 'backend', 'Product Import / Error access denied', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjBaseField', '::LOCALE::', 'title', 'Access denied.', 'script');

INSERT INTO `fields` VALUES (NULL, 'import_err_expired', 'backend', 'Product Import / Error session expired', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjBaseField', '::LOCALE::', 'title', 'The import session expired. Please upload the file again.', 'script');

INSERT INTO `fields` VALUES (NULL, 'import_delimiter_label', 'backend', 'Product Import / Delimiter label', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjBaseField', '::LOCALE::', 'title', 'Column separator', 'script');

INSERT INTO `fields` VALUES (NULL, 'import_delimiter_auto', 'backend', 'Product Import / Delimiter auto', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjBaseField', '::LOCALE::', 'title', 'Auto-detect (recommended)', 'script');

INSERT INTO `fields` VALUES (NULL, 'import_delimiter_comma', 'backend', 'Product Import / Delimiter comma', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjBaseField', '::LOCALE::', 'title', 'Comma  ( , )', 'script');

INSERT INTO `fields` VALUES (NULL, 'import_delimiter_semicolon', 'backend', 'Product Import / Delimiter semicolon', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjBaseField', '::LOCALE::', 'title', 'Semicolon  ( ; )', 'script');

INSERT INTO `fields` VALUES (NULL, 'import_delimiter_hint', 'backend', 'Product Import / Delimiter hint', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjBaseField', '::LOCALE::', 'title', 'Not sure? Leave Auto-detect - it reads the first line and picks the right separator.', 'script');

INSERT INTO `fields` VALUES (NULL, 'import_err_headers', 'backend', 'Product Import / Error header separator mismatch', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjBaseField', '::LOCALE::', 'title', 'Your file looks {DETECTED}-separated, but the column separator is set to {SELECTED}. Choose the matching separator (or use Auto-detect) and import again.', 'script');

INSERT INTO `fields` VALUES (NULL, 'import_err_headers_auto', 'backend', 'Product Import / Error header columns missing', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjBaseField', '::LOCALE::', 'title', 'Could not find the required columns (product_name and sku). Make sure the first row is a header row and the file uses comma or semicolon separators.', 'script');

INSERT INTO `fields` VALUES (NULL, 'import_detail_variants', 'backend', 'Product Import / Detail variants', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjBaseField', '::LOCALE::', 'title', '{COUNT} variant(s)', 'script');

INSERT INTO `fields` VALUES (NULL, 'import_detail_attributes', 'backend', 'Product Import / Detail attributes', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjBaseField', '::LOCALE::', 'title', '{COUNT} attribute group(s)', 'script');

INSERT INTO `fields` VALUES (NULL, 'import_detail_images', 'backend', 'Product Import / Detail images', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjBaseField', '::LOCALE::', 'title', '{COUNT} image(s)', 'script');

INSERT INTO `fields` VALUES (NULL, 'import_detail_extras', 'backend', 'Product Import / Detail extras', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjBaseField', '::LOCALE::', 'title', '{COUNT} extra(s)', 'script');

INSERT INTO `fields` VALUES (NULL, 'import_detail_categories', 'backend', 'Product Import / Detail categories', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjBaseField', '::LOCALE::', 'title', '{COUNT} categories', 'script');

INSERT INTO `fields` VALUES (NULL, 'import_detail_similar', 'backend', 'Product Import / Detail similar', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjBaseField', '::LOCALE::', 'title', '{COUNT} similar', 'script');

INSERT INTO `fields` VALUES (NULL, 'menuProductImport', 'backend', 'Left menu / Import products', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjBaseField', '::LOCALE::', 'title', 'Import products', 'script');

INSERT INTO `fields` VALUES (NULL, 'import_err_category', 'backend', 'Product Import / Error category required', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjBaseField', '::LOCALE::', 'title', 'at least one category is required', 'script');

INSERT INTO `fields` VALUES (NULL, 'import_err_short', 'backend', 'Product Import / Error short description required', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjBaseField', '::LOCALE::', 'title', 'short_description is required', 'script');

INSERT INTO `fields` VALUES (NULL, 'import_err_dup_sku', 'backend', 'Product Import / Error duplicate SKU in file', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjBaseField', '::LOCALE::', 'title', 'duplicate SKU - already used on row {LINE} of this file', 'script');

INSERT INTO `fields` VALUES (NULL, 'import_help_required', 'backend', 'Product Import / Help required columns', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjBaseField', '::LOCALE::', 'title', 'Required columns: product_name, sku, categories, short_description. Rows missing any of these are skipped and listed with the reason.', 'script');

INSERT INTO `fields` VALUES (NULL, 'import_help_digital', 'backend', 'Product Import / Help digital', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjBaseField', '::LOCALE::', 'title', 'digital_name, digital_expire - for digital products (is_digital = Yes). digital_file - optional: a re-exported download link, a public URL, or a server file path; the file is fetched and attached on import. Leave blank to upload it on the product instead.', 'script');

INSERT INTO `fields` VALUES (NULL, 'product_delete_has_orders', 'backend', 'Products / Delete has orders', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjBaseField', '::LOCALE::', 'title', 'This product is linked to %d order(s). The orders are kept, but those order lines will no longer show the product name or image. Delete anyway?', 'script');

INSERT INTO `fields` VALUES (NULL, 'product_delete_has_orders_bulk', 'backend', 'Products / Delete has orders (bulk)', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjBaseField', '::LOCALE::', 'title', 'The selected products are linked to %d order(s). The orders are kept, but those order lines will no longer show the product name or image. Delete anyway?', 'script');

INSERT INTO `fields` VALUES (NULL, 'import_help_notes_title', 'backend', 'Product Import / Help notes title', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjBaseField', '::LOCALE::', 'title', 'Good to know', 'script');

INSERT INTO `fields` VALUES (NULL, 'import_help_note_validation', 'backend', 'Product Import / Help note validation', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjBaseField', '::LOCALE::', 'title', 'Each row is validated on its own - invalid rows are skipped and listed below, valid rows still import.', 'script');

INSERT INTO `fields` VALUES (NULL, 'import_help_note_separator', 'backend', 'Product Import / Help note separator', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjBaseField', '::LOCALE::', 'title', 'Columns may be comma- or semicolon-separated. Leave the separator on Auto-detect if you are unsure.', 'script');

INSERT INTO `fields` VALUES (NULL, 'import_help_note_images', 'backend', 'Product Import / Help note images', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjBaseField', '::LOCALE::', 'title', 'Photo URLs must be reachable by the server. Re-exporting produces a self-contained file whose images restore even after products are deleted.', 'script');

INSERT INTO `fields` VALUES (NULL, 'import_sample_download', 'backend', 'Product Import / Download sample', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjBaseField', '::LOCALE::', 'title', 'Download sample CSV', 'script');

INSERT INTO `fields` VALUES (NULL, 'import_help_sample', 'backend', 'Product Import / Help sample', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjBaseField', '::LOCALE::', 'title', 'New to importing? The sample CSV shows a variant product (with multiple attributes and both extra types), a digital product and a hidden one. It imports as-is, so use it as your starting template:', 'script');
