{"slug":"colisly","name":"Parcel Forwarding & Package Consolidation for WooCommerce","description":"Run a package forwarding business on WooCommerce: parcel intake, storage fees, consolidation, reshipping and a client portal.","author":"MVaertan (Pixfeed)","active_installs":0,"version":"1.30.0","wp_org_url":"https://wordpress.org/plugins/colisly/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":true,"deletes_options_on_uninstall":true},"tables":[{"table_name":"colisly_","full_table_name":"wp_colisly_","description":"Stores colisly  data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"colisly_clients","full_table_name":"wp_colisly_clients","description":"Stores colisly clients data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"user_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"reference","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"phone","type":"VARCHAR(50)","nullable":false,"primary_key":false},{"name":"admin_notes","type":"TEXT","nullable":true,"primary_key":false},{"name":"discount_rate","type":"DECIMAL(5,2)","nullable":false,"primary_key":false},{"name":"discount_scope","type":"VARCHAR(10)","nullable":false,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"updated_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"reference","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"client_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"tracking_number","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"weight","type":"DECIMAL(10,3)","nullable":false,"primary_key":false},{"name":"length","type":"DECIMAL(10,2)","nullable":true,"primary_key":false},{"name":"width","type":"DECIMAL(10,2)","nullable":true,"primary_key":false},{"name":"height","type":"DECIMAL(10,2)","nullable":true,"primary_key":false},{"name":"photo_id","type":"BIGINT UNSIGNED","nullable":true,"primary_key":false},{"name":"photo_path","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"internal_note","type":"TEXT","nullable":true,"primary_key":false},{"name":"allow_grouping","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"allowed_carriers","type":"TEXT","nullable":true,"primary_key":false},{"name":"price","type":"DECIMAL(12,2)","nullable":false,"primary_key":false},{"name":"advanced_fees","type":"DECIMAL(12,2)","nullable":false,"primary_key":false},{"name":"advanced_fees_label","type":"VARCHAR(190)","nullable":false,"primary_key":false},{"name":"status","type":"VARCHAR(30)","nullable":false,"primary_key":false},{"name":"shipment_id","type":"BIGINT UNSIGNED","nullable":true,"primary_key":false},{"name":"received_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"shipped_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"created_by","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"updated_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"reference","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"client_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"order_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"carrier","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"status","type":"VARCHAR(30)","nullable":false,"primary_key":false},{"name":"total_weight","type":"DECIMAL(10,3)","nullable":false,"primary_key":false},{"name":"total_price","type":"DECIMAL(12,2)","nullable":false,"primary_key":false},{"name":"storage_fees","type":"DECIMAL(12,2)","nullable":false,"primary_key":false},{"name":"carrier_price","type":"DECIMAL(12,2)","nullable":false,"primary_key":false},{"name":"destination_country","type":"VARCHAR(2)","nullable":false,"primary_key":false},{"name":"insured_value","type":"DECIMAL(12,2)","nullable":false,"primary_key":false},{"name":"insurance_price","type":"DECIMAL(12,2)","nullable":false,"primary_key":false},{"name":"discount","type":"DECIMAL(12,2)","nullable":false,"primary_key":false},{"name":"discount_label","type":"VARCHAR(190)","nullable":false,"primary_key":false},{"name":"requested_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"shipped_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"updated_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"parcel_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"shipment_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"description","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"quantity","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"unit_weight","type":"DECIMAL(10,3)","nullable":false,"primary_key":false},{"name":"unit_value","type":"DECIMAL(12,2)","nullable":false,"primary_key":false},{"name":"origin_country","type":"VARCHAR(2)","nullable":false,"primary_key":false},{"name":"hs_code","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"position","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"updated_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"client_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"attachment_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"file_path","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"file_name","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"mime_type","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"title","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"visibility","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"uploaded_by","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"parcel_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"shipment_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"kind","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"client_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"parcel_id","type":"BIGINT UNSIGNED","nullable":true,"primary_key":false},{"name":"shipment_id","type":"BIGINT UNSIGNED","nullable":true,"primary_key":false},{"name":"event","type":"VARCHAR(50)","nullable":false,"primary_key":false},{"name":"message","type":"TEXT","nullable":true,"primary_key":false},{"name":"user_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_colisly_clients ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, user_id BIGINT UNSIGNED NOT NULL, reference VARCHAR(20) NOT NULL DEFAULT '', phone VARCHAR(50) NOT NULL DEFAULT '', admin_notes TEXT NULL, discount_rate DECIMAL(5,2) NOT NULL DEFAULT 0, discount_scope VARCHAR(10) NOT NULL DEFAULT 'handling', created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, PRIMARY KEY (id), UNIQUE KEY user_id (user_id), UNIQUE KEY reference (reference) ) $collate; CREATE TABLE wp_colisly_parcels ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, reference VARCHAR(20) NOT NULL DEFAULT '', client_id BIGINT UNSIGNED NOT NULL, tracking_number VARCHAR(100) NOT NULL DEFAULT '', weight DECIMAL(10,3) NOT NULL DEFAULT 0, length DECIMAL(10,2) NULL, width DECIMAL(10,2) NULL, height DECIMAL(10,2) NULL, photo_id BIGINT UNSIGNED NULL, photo_path VARCHAR(255) NOT NULL DEFAULT '', internal_note TEXT NULL, allow_grouping TINYINT(1) NOT NULL DEFAULT 1, allowed_carriers TEXT NULL, price DECIMAL(12,2) NOT NULL DEFAULT 0, advanced_fees DECIMAL(12,2) NOT NULL DEFAULT 0, advanced_fees_label VARCHAR(190) NOT NULL DEFAULT '', status VARCHAR(30) NOT NULL DEFAULT 'available', shipment_id BIGINT UNSIGNED NULL, received_at DATETIME NOT NULL, shipped_at DATETIME NULL, created_by BIGINT UNSIGNED NOT NULL DEFAULT 0, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, PRIMARY KEY (id), UNIQUE KEY reference (reference), KEY client_id (client_id), KEY status (status), KEY shipment_id (shipment_id) ) $collate; CREATE TABLE wp_colisly_shipments ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, reference VARCHAR(20) NOT NULL DEFAULT '', client_id BIGINT UNSIGNED NOT NULL, order_id BIGINT UNSIGNED NOT NULL DEFAULT 0, carrier VARCHAR(100) NOT NULL DEFAULT '', status VARCHAR(30) NOT NULL DEFAULT 'requested', total_weight DECIMAL(10,3) NOT NULL DEFAULT 0, total_price DECIMAL(12,2) NOT NULL DEFAULT 0, storage_fees DECIMAL(12,2) NOT NULL DEFAULT 0, carrier_price DECIMAL(12,2) NOT NULL DEFAULT 0, destination_country VARCHAR(2) NOT NULL DEFAULT '', insured_value DECIMAL(12,2) NOT NULL DEFAULT 0, insurance_price DECIMAL(12,2) NOT NULL DEFAULT 0, discount DECIMAL(12,2) NOT NULL DEFAULT 0, discount_label VARCHAR(190) NOT NULL DEFAULT '', requested_at DATETIME NOT NULL, shipped_at DATETIME NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, PRIMARY KEY (id), UNIQUE KEY reference (reference), KEY client_id (client_id), KEY status (status) ) $collate; CREATE TABLE wp_colisly_customs_items ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, parcel_id BIGINT UNSIGNED NOT NULL DEFAULT 0, shipment_id BIGINT UNSIGNED NOT NULL DEFAULT 0, description VARCHAR(255) NOT NULL DEFAULT '', quantity INT UNSIGNED NOT NULL DEFAULT 1, unit_weight DECIMAL(10,3) NOT NULL DEFAULT 0, unit_value DECIMAL(12,2) NOT NULL DEFAULT 0, origin_country VARCHAR(2) NOT NULL DEFAULT '', hs_code VARCHAR(20) NOT NULL DEFAULT '', position INT UNSIGNED NOT NULL DEFAULT 0, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, PRIMARY KEY (id), KEY parcel_id (parcel_id), KEY shipment_id (shipment_id) ) $collate; CREATE TABLE wp_colisly_documents ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, client_id BIGINT UNSIGNED NOT NULL, attachment_id BIGINT UNSIGNED NOT NULL DEFAULT 0, file_path VARCHAR(255) NOT NULL DEFAULT '', file_name VARCHAR(255) NOT NULL DEFAULT '', mime_type VARCHAR(100) NOT NULL DEFAULT '', title VARCHAR(255) NOT NULL DEFAULT '', visibility VARCHAR(20) NOT NULL DEFAULT 'client', uploaded_by BIGINT UNSIGNED NOT NULL DEFAULT 0, parcel_id BIGINT UNSIGNED NOT NULL DEFAULT 0, shipment_id BIGINT UNSIGNED NOT NULL DEFAULT 0, kind VARCHAR(20) NOT NULL DEFAULT '', created_at DATETIME NOT NULL, PRIMARY KEY (id), KEY client_id (client_id), KEY parcel_id (parcel_id), KEY shipment_id (shipment_id) ) $collate; CREATE TABLE wp_colisly_history ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, client_id BIGINT UNSIGNED NOT NULL, parcel_id BIGINT UNSIGNED NULL, shipment_id BIGINT UNSIGNED NULL, event VARCHAR(50) NOT NULL DEFAULT '', message TEXT NULL, user_id BIGINT UNSIGNED NOT NULL DEFAULT 0, created_at DATETIME NOT NULL, PRIMARY KEY (id), KEY client_id (client_id), KEY parcel_id (parcel_id), KEY event (event) ) $collate; \"; dbDelta( $tables );"},{"table_name":"colisly_customs_items","full_table_name":"wp_colisly_customs_items","description":"Stores colisly customs items data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"colisly_documents","full_table_name":"wp_colisly_documents","description":"Stores colisly documents data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"colisly_history","full_table_name":"wp_colisly_history","description":"Stores colisly history data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"colisly_parcels","full_table_name":"wp_colisly_parcels","description":"Stores colisly parcels data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"colisly_shipments","full_table_name":"wp_colisly_shipments","description":"Stores colisly shipments data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"gcp_","full_table_name":"wp_gcp_","description":"Stores gcp  data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null}],"table_count":8}