Question: Excel Mass Import Not Working

Excel Mass Import Not Working

When I import items from xls, it says oke, but no items appear in the listing.

MV

Michiel Visser

Asked
When I import items from xls, it says oke, but no items appear in the listing.
  • MV

    Michiel Visser

    Answered
    And on a mutiple option product, when i make a purchase order, iget the following error:

    Failed!

    500: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'store_id' cannot be null (Connection: mysql, SQL: insert into `purchases` (`date`, `reference`, `supplier_id`, `details`, `status`, `total`, `total_items`, `subtotal`, `grand_total`, `total_quantity`, `total_tax_amount`, `total_discount_amount`, `company_id`, `register_id`, `store_id`, `user_id`, `updated_at`, `created_at`) values (2025-04-10 00:00:00, 01jrf21d8r6aktcmftf98zx483, 1, ?, Received, 180.00, 1.00, 180.00, 180.00, 12, 0.00, 0.00, 1, ?, ?, 1, 2025-04-10 05:16:22, 2025-04-10 05:16:22))
  • MS

    Mian Saleem

    Answered
    Hello,

    Can you please take full page screenshot. I suspect you posted at the wrong item. WIMS doesn't have purchase options.

    Thank you
  • MV

    Michiel Visser

    Answered
    This is the page the error apears when posted. Don't know wich one of the 6 programss it is, i have them all :P
  • MS

    Mian Saleem

    Answered
    That's SMA v4, it's still beta and under development. I will check and fix this in the next beta update. Thank you
  • Login to Reply