Settings
ConfigurationConnectionsIntergrationsAI SettingsLocationsUnitsTaxesResourcesOperationsCurrenciesPrint templatesCategoriesTemplate PageImport Data
System setup
Import Data
On page load we check original KATANA tables for new rows. Import inserts only missing rows to avoid duplicates.
Last import: 10/15/2026, 10:49:50 PM
Import source
Using KATANA API URL: https://api.katanamrp.com
ON DEMANDAPI is contacted only when you run an import.
SKALARKI tables
Tables and Record Counts
Showing live source counts from KATANA. Import is enabled only when new rows are available.
| Table | Source | Target | Source Count | Target Count | New Rows | Last Source ID | Last Import | Action | |
|---|---|---|---|---|---|---|---|---|---|
| Suppliers | katana_suppliers | public.skalarki_suppliers | 312 | 312 | 0 | 1701805 | 10/15/2026, 10:01:28 PM | ||
| Purchase Order Rows | katana_purchase_order_rows | public.skalarki_purchase_order_rows | 8,501 | 8,501 | 0 | 8822450 | 10/15/2026, 10:08:51 PM | ||
| Materials | katana_materials | public.skalarki_materials | 1,598 | 1,598 | 0 | 18174311 | 10/15/2026, 10:04:58 PM | ||
| Inventory Movements | katana_inventory_movements | public.skalarki_inventory_movements | 63,797 | 63,797 | 0 | 288477169 | 10/15/2026, 10:49:50 PM | ||
| Customers | katana_customers | public.skalarki_customers | 1,908 | 1,908 | 0 | 114592373 | 10/15/2026, 10:41:06 PM | ||
| Inventory | katana_inventory | public.skalarki_inventory | 0 | 0 | 0 | 0 | 10/15/2026, 10:19:03 PM | ||
| Stocktakes | katana_stocktakes | public.skalarki_stocktakes | 44 | 44 | 0 | 173529 | 10/15/2026, 10:14:06 PM | ||
| Services | katana_services | public.skalarki_services | 1 | 1 | 0 | 14773236 | 10/15/2026, 10:05:06 PM | ||
| Users | katana_users | public.skalarki_users | 19 | 19 | 0 | 140575 | 10/15/2026, 10:24:18 PM | ||
| Stock Transfers | katana_stock_transfers | public.skalarki_stock_transfers | 0 | 0 | 0 | 0 | 10/15/2026, 10:23:34 PM | ||
| Sales Order Fulfillments | katana_sales_order_fulfillments | public.skalarki_sales_order_fulfillments | 1,886 | 1,886 | 0 | 47155475 | 10/15/2026, 10:07:59 PM | ||
| Sales Order Addresses | katana_sales_order_addresses | public.skalarki_sales_order_addresses | 27,789 | 27,789 | 0 | 61945943 | 10/15/2026, 10:07:47 PM | ||
| Sales Orders | katana_sales_orders | public.skalarki_sales_orders | 1,926 | 1,926 | 0 | 53284278 | 10/15/2026, 10:05:36 PM | ||
| Stock Adjustments | katana_stock_adjustments | public.skalarki_stock_adjustments | 108 | 108 | 0 | 2705166 | 10/15/2026, 10:23:26 PM | ||
| Manufacturing Orders | katana_manufacturing_orders | public.skalarki_manufacturing_orders | 7,796 | 7,796 | 0 | 19622546 | 10/15/2026, 10:09:21 PM | ||
| Purchase Order Accounting Metadata | katana_purchase_order_accounting_metadata | public.skalarki_purchase_order_accounting_metadata | 3 | 3 | 0 | 0 | 10/15/2026, 10:09:00 PM | ||
| Manufacturing Order Operation Rows | katana_manufacturing_order_operation_rows | public.skalarki_manufacturing_order_operation_rows | 12,784 | 12,784 | 0 | 32418743 | 10/15/2026, 10:09:59 PM | ||
| User Info | katana_user_info | public.skalarki_user_info | 6 | 6 | 0 | 0 | 10/15/2026, 10:24:09 PM | ||
| Serial Numbers | katana_serial_numbers | public.skalarki_serial_numbers | 0 | 0 | 0 | 0 | 10/15/2026, 10:23:12 PM | ||
| Bin Inventory | katana_bin_inventory | public.skalarki_bin_inventory | 0 | 0 | 0 | 0 | 10/15/2026, 10:22:12 PM | ||
| Outsourced Purchase Order Recipe Rows | katana_outsourced_purchase_order_recipe_rows | public.skalarki_outsourced_purchase_order_recipe_rows | 0 | 0 | 0 | 0 | 10/15/2026, 10:17:47 PM | ||
| Sales Order Rows | katana_sales_order_rows | public.skalarki_sales_order_rows | 3,605 | 3,605 | 0 | 126414077 | 10/15/2026, 10:05:48 PM | ||
| Manufacturing Order Productions | katana_manufacturing_order_productions | public.skalarki_manufacturing_order_productions | 8,272 | 8,272 | 0 | 16741536 | 10/15/2026, 10:10:56 PM | ||
| Sales Order Shipping Fee | katana_sales_order_shipping_fee | public.skalarki_sales_order_shipping_fee | 12 | 12 | 0 | 13161716 | 10/15/2026, 10:08:07 PM | ||
| Tax Rates | katana_tax_rates | public.skalarki_tax_rates | 31 | 31 | 0 | 512838 | 10/15/2026, 10:23:51 PM | ||
| Locations | katana_locations | public.skalarki_locations | 3 | 3 | 0 | 205684 | 10/15/2026, 10:01:36 PM | ||
| Products | katana_products | public.skalarki_products | 1,187 | 1,187 | 0 | 18144166 | 10/15/2026, 10:04:47 PM | ||
| Recipes | katana_recipes | public.skalarki_recipes | 11,158 | 11,158 | 0 | 0 | 8/28/2026, 10:34:22 PM | ||
| Variants | katana_variants | public.skalarki_variants | 4,202 | 4,202 | 0 | 42484933 | 10/15/2026, 10:05:19 PM | ||
| Stocktake Rows | katana_stocktake_rows | public.skalarki_stocktake_rows | 42,723 | 42,723 | 0 | 7484565 | 10/15/2026, 10:16:57 PM | ||
| Sales Order Accounting Metadata | katana_sales_order_accounting_metadata | public.skalarki_sales_order_accounting_metadata | 0 | 0 | 0 | 0 | 10/15/2026, 10:08:16 PM | ||
| Manufacturing Order Recipe Rows | katana_manufacturing_order_recipe_rows | public.skalarki_manufacturing_order_recipe_rows | 57,933 | 57,933 | 0 | 112487876 | 10/15/2026, 10:42:42 PM | ||
| Purchase Orders | katana_purchase_orders | public.skalarki_purchase_orders | 2,666 | 2,666 | 0 | 3053831 | 10/15/2026, 10:08:34 PM | ||
| Batches | katana_batches | public.skalarki_batches | 0 | 0 | 0 | 0 | - | ||
| Brands | katana_brands | public.skalarki_brands | 0 | 0 | 0 | 0 | - | ||
| Contacts | katana_contacts | public.skalarki_contacts | 0 | 0 | 0 | 0 | - | ||
| Currencies | katana_currencies | public.skalarki_currencies | 6 | 6 | 0 | 0 | - | ||
| Inventory Reorder Points | katana_inventory_reorder_points | public.skalarki_inventory_reorder_points | 0 | 0 | 0 | 0 | - | ||
| Inventory Safety Stock Levels | katana_inventory_safety_stock_levels | public.skalarki_inventory_safety_stock_levels | 0 | 0 | 0 | 0 | - | ||
| Outsourced Purchase Orders | katana_outsourced_purchase_orders | public.skalarki_outsourced_purchase_orders | 0 | 0 | 0 | 0 | - | ||
| Outsourced Purchase Order Rows | katana_outsourced_purchase_order_rows | public.skalarki_outsourced_purchase_order_rows | 0 | 0 | 0 | 0 | - | ||
| Price Lists | katana_price_lists | public.skalarki_price_lists | 0 | 0 | 0 | 0 | - | ||
| Price List Rows | katana_price_list_rows | public.skalarki_price_list_rows | 0 | 0 | 0 | 0 | - | ||
| Price List Customers | katana_price_list_customers | public.skalarki_price_list_customers | 0 | 0 | 0 | 0 | - | ||
| Product Categories | katana_product_categories | public.skalarki_product_categories | 86 | 86 | 0 | 0 | - | ||
| Tasks | katana_tasks | public.skalarki_tasks | 0 | 0 | 0 | 0 | - | ||
| Units | katana_units | public.skalarki_units | 24 | 24 | 0 | 0 | - | ||
| Variant Bin Locations | katana_variant_bin_locations | public.skalarki_variant_bin_locations | 0 | 0 | 0 | 0 | - | ||
| Warehouses | katana_warehouses | public.skalarki_warehouses | 0 | 0 | 0 | 0 | - | ||
| Work Stations | katana_work_stations | public.skalarki_work_stations | 13 | 13 | 0 | 0 | - |