shop
Queries
- Product Gallery (with images)
- Product List (links only)
- Products In Stock
- Products Out of Stock
- Norwegian Products
- English Products
- NO/EN Translation Pairs
- NO/EN Pairs with Differences
- NO/EN Pairs with Language Conflicts
- Products with Language but No Translation Pair
- Potential Pairs - Same Image
- Potential Pairs - Same Prices, No Pair
- Products with Price Variants
- Category Product Counts
- Categories by Master Category
- Master Category Summary
- Products with Norwegian Characters (æøå)
- Non-Square Product Images
- Product Details (with backend data)
Tables
categories
id, name, type, master_category, status, language, sort_order, title, description, seo_content, breadcrumb_trail, canonical, heading, menu_name, date_limit, next_day_only, preorder, product_count, scraped_at
107 rows
import_history
id, import_type, source_file, records_processed, records_created, records_updated, errors, started_at, completed_at
3 rows
product_backend_data
product_id, instock, inventory, useinventory, autostock, sku, title, url_slug, saleprice, special, saleexpire, alcohol, floral, addon, restricted, vase, raw_data, scraped_at
535 rows
product_images
id, product_id, size, remote_url, local_path, downloaded_at, file_size, http_status, width, height, md5_hash
535 rows
products
id, name, colour, description, page_title, url_slug, categories_raw, language, created_at, updated_at
535 rows