Open Source Point of Sale / Support Requests / #19 excel import

#19 excel import

Milestone: v1.0_(example)

Status: closed

Owner: nobody

Labels: None

Priority: 1

Updated: 2015-03-23

Created: 2013-07-14

Creator: Anonymous

Private: No

cannot import excel csv format more then once. even when i add new csv items. how to sort this??

Discussion

Anonymous - 2013-09-07

Having Same error . Not able to solve any update on this

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Anonymous - 2013-09-12

I am having same problem it will work only once. Second time nothing will happens. Any suggestions??

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Anonymous - 2013-10-07

Just to jump on the bandwagon, I can't upload items either...

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Anonymous - 2014-10-28

Yeah, me either.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

jekkos - 2015-02-17

should be fixed in latest version

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

jekkos - 2015-02-17

status: open --> closed
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Anonymous - 2015-02-27

Post awaiting moderation.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

jekkos - 2015-02-27

did you use the excel template attached to the application? There are some required changes you will need to make to your own such as defining the location id for each quantity you want to import. Make sure you get this right before you try.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Anonymous - 2015-03-22

Post awaiting moderation.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

jekkos - 2015-03-23

You can try to remove it on database level. However I'm not sure whether the code will find multiple records or only the non deleted ones in this case.

Another option might be to undelete the item and change it's upc number. Then redo the import. There's a filter to show deleted items in the search options.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Francesco - 2015-03-23

The issue is probably a matter of two cases:

the item with that UPC number was deleted and needs to be undeleted (I had this issue several time because in clothing accessories or certain shoes might come back after 1 year or so with same barcode)

the item exists already but maybe we want to update the quantity

It's difficult to say what the best user experience for the case is because it's like when you merge two codelines and you have a conflict.
I guess the ideal case would be to have a view resolving the conflict and ask the user:
- resume the undeleted?
- increase the quantity?

Of course just a thought here.... new feature space :-)
If you would like to refer to this comment somewhere else in this project, copy and paste the following link: