Bulk Upload CSV

askmathew2020

I was trying the upload the Menu items in another store a bulk upload through CSV, expect the image other details get stored, but for image, i was getting an Error as

" Total Errors: 1

"image" filename is invalid for masala
"
I wanna know what exactly we need to type for images in CSV. I have read documentation, even then am unable to do so.

Ricesy

We should type NULL in column of image name, where you doesn't want to attach image.

SebastianCamia

Why csv refuses to work?
This is the error i get while in development mode:

"Undefined index: restaurant_id"

It is weird because my restaurant id is number 2.. idk what is wrong really

This is how my csv looks like:

name;restaurant_id;item_category_id;price;image;is_recommended;is_popular;is_new;desc;is_veg
Aperol;2;48;520;/assets/img/items/bebidacallejera/aperitivos/aperol.jpg ;1;1;1;NULL;1
Campari;2;48;450;/assets/img/items/bebidacallejera/aperitivos/campari.jpg ;1;1;1;NULL;1
Cazalis;2;48;200;/assets/img/items/bebidacallejera/aperitivos/cazalis.jpg ;1;1;1;NULL;1
Cinzano;2;48;280;/assets/img/items/bebidacallejera/aperitivos/cinzano.jpg ;1;1;1;NULL;1
Cynar;2;48;340;/assets/img/items/bebidacallejera/aperitivos/Cynar.jpg ;1;1;1;NULL;1

Kara

You have semicolon ; that’s the issue you need , when you open the file then select as separator , not ;

SebastianCamia

No, i have also tried the sample csv and its not working either; it is not a separator issue.

Kara

Trust me I has the same error bro

Kara

When you save the file on your pc it’s change automatically look download fresh csv and ope with text editor you will See , but when you change it with excel and save and open with text editor change it to ; and that’s the issue

Kara

And image must be NULL

SebastianCamia

Well you are right..

I dont understand why i cant load the images.. it is pointless to make a bulk upload with no images..

wpradobr

SebastianCamia check thedocs... imagens need to be uploaded b4 🙂 WORKS perfect here.

SebastianCamia

Thanks for your help bro

DeepakM

Any way to upload Multiple Selection values in the bulk file upload for items?

JuniorGordon

Hey Everyone,

I am trying to perform a bulk upload but I am constantly faced with errors. Can anyone lend a hand please?

After uploading CSV i'm prompted to download a error txt file with this next to all items "item_category_id" is invalid for" All fields have either a 1 or 0 and images are set to NULL

Thanks

NikhilJain

JuniorGordon Check your category ID well

JuniorGordon

Can anyone assist me with this error that i'm getting during bulk item upload.

Thank you

ventis

JuniorGordon getting same error here