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 😛

  • 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