{"joins": [{"type": "left", "first": "products.category_id", "table": "product_categories", "second": "product_categories.category_id", "operator": "="}], "table": "products", "columns": ["product_id", "name", "description", "price", "quantity", "barcode", "brand", "product_number", "category_id", "tax_rates"], "filters": {"isDeleted": false}, "filename": "products_catalog", "order_by": {"name": "ASC"}, "transforms": {"price": {"type": "number", "decimals": 2}, "quantity": {"type": "number", "decimals": 0}, "category_id": {"type": "lookup", "table": "product_categories", "key_column": "name", "value_column": "category_id"}}, "primary_key": "product_id", "validations": {"name": {"required": true, "max_length": 255}, "price": {"required": false}}, "field_labels": {"name": "Name", "brand": "Brand", "price": "Price", "barcode": "Barcode", "quantity": "Quantity", "product_id": "Product ID", "description": "Description", "product_number": "Product Number"}, "unique_fields": ["barcode", "product_number"], "field_mappings": {"Name": "name", "Brand": "brand", "Price": "price", "Barcode": "barcode", "Category": "category_id", "Quantity": "quantity", "STT Rate": {"column": "tax_rates", "json_field": "stt"}, "VAT Rate": {"column": "tax_rates", "json_field": "vat"}, "Product ID": "product_id", "Description": "description", "Product Number": "product_number"}, "update_existing": true, "export_transforms": {"price": {"type": "number", "decimals": 2}, "tax_rates": {"type": "json_decode"}, "category_id": {"type": "lookup", "table": "product_categories", "key_column": "category_id", "display_column": "name"}}}