Subscribe via rss
Discussions
Guest
or Ask a Question
Add a reply View Replies (10) →
wick schalkwyk
wick schalkwyk
Offline

excel import failure

I'm new to Arastta and for some reason I'm unable to upload my excel sheet with products.
I've had many error logs but now deleted all products online, however I'm still getting this message:

2015-10-06 10:57:21 - Export/Import: Missing product_ids in worksheet 'Products'!
2015-10-06 10:57:57 - Export/Import: Missing product_ids in worksheet 'Products'!

This is my format with product ID and catagory ID included:
52 Bains Whiskey 72 South Africa 1200 750ml BAINS yes 220.00 2200 0000-00-00 00:00:00 0000-00-00 00:00:00 2015-10-05 0.00 kg 0 0 0 cm true 11 bains-whiskey
Bains Whiskey 7 0 0: 1 true 1

So before I deleted all products, I've tried export and copy all items as per export sheet but also did not work.

Can you assist in this please?:(
In Installation & Update
Tuesday, October 06 2015, 02:36 PM
Share this post:

Accepted Answer

Ahmet Kurucan
Ahmet Kurucan
Offline
Wednesday, October 07 2015, 02:06 PM - #Permalink
Wick, can you please try LibreOffice or OpenOffice because I'm reading that MS Excel has an incompatibility with the PHPExcel library used by Arastta to read XLS files.

Also, product_id must be like 50 not 50.00
The reply is currently minimized Show
Responses (10)

  • Accepted Answer

    Glen Smale
    Glen Smale
    Offline
    Sunday, March 25 2018, 10:19 AM - #Permalink
    So I know this post is old however I recently started with Arastta. Great software by the way... and imported an excel products.xlsx spreadsheet using the Export / Import feature in Arastta and also received the same error message: "error: Missing product_id".

    To solve this issue you simply delete all the empty rows after the last product_id in your spreadsheet. For verbosity you select the empty rows after the last product_id field and drag down, then right click the rows and delete. If you use google spreadsheets this works really well as you can set the number of rows.
    The reply is currently minimized Show

  • Accepted Answer

    wick schalkwyk
    wick schalkwyk
    Offline
    Wednesday, October 07 2015, 04:23 PM - #Permalink
    Thank you, open office worked :)
    The reply is currently minimized Show

  • Accepted Answer

    wick schalkwyk
    wick schalkwyk
    Offline
    Wednesday, October 07 2015, 11:53 AM - #Permalink
    See copy of file attached.
    Attachments:
    The reply is currently minimized Show

  • Accepted Answer

    wick schalkwyk
    wick schalkwyk
    Offline
    Wednesday, October 07 2015, 11:52 AM - #Permalink
    See copy of file attached.
    The reply is currently minimized Show

  • Accepted Answer

    wick schalkwyk
    wick schalkwyk
    Offline
    Wednesday, October 07 2015, 11:49 AM - #Permalink
    Also changed it to numbers and still giving error: Missing product_id :(
    The reply is currently minimized Show

  • Accepted Answer

    wick schalkwyk
    wick schalkwyk
    Offline
    Wednesday, October 07 2015, 11:43 AM - #Permalink
    I have change that to general and still not working?
    The reply is currently minimized Show

  • Accepted Answer

    Ahmet Kurucan
    Ahmet Kurucan
    Offline
    Wednesday, October 07 2015, 09:40 AM - #Permalink
    The program you've been using seems to not set those as number but text, see the attached error. You should convert them to numbers.
    Attachments:
    The reply is currently minimized Show

  • Accepted Answer

    wick schalkwyk
    wick schalkwyk
    Offline
    Tuesday, October 06 2015, 03:02 PM - #Permalink
    I must add, I have deleted the products and not sure how this will affect the product ID's as I see the ID's cannot be used again?
    The reply is currently minimized Show

  • Accepted Answer

    wick schalkwyk
    wick schalkwyk
    Offline
    Tuesday, October 06 2015, 02:58 PM - #Permalink
    Hi Ahmet,

    Please see attached.

    Thank you:)
    Attachments:
    The reply is currently minimized Show

  • Accepted Answer

    Ahmet Kurucan
    Ahmet Kurucan
    Offline
    Tuesday, October 06 2015, 02:40 PM - #Permalink
    Welcome to Arastta Wick, you can be sure you won't leave it :p

    Can you please upload the sheet here with a product as example? Don't forget to ZIP it first.
    The reply is currently minimized Show
Your Reply