excel import failure

Offline

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

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

Ahmet Kurucan

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

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
Accepted Answer
wick schalkwyk

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

Please see attached.

Thank you

Attachments:

products-2015-10-06-2.zip
The reply is currently minimized Show
Accepted Answer
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

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:

2015-10-07_0937.png
The reply is currently minimized Show
Accepted Answer
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
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

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

Offline
Wednesday, October 07 2015, 11:53 AM - #Permalink
See copy of file attached.

Attachments:

Products-2015-10-07.zip
The reply is currently minimized Show
Accepted Answer
wick schalkwyk

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

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