Jun 15, 2013
Rafa Ceres
wrote
Hello!
I purchased Store Manager a couple of months ago. We have used it to generate product labels with barcodes and we use the integrated POS with a barcode reader in the local shop to remove products we sell in the moment.
The task to label products was easy the first time, as all products were unlabelled and we had just to generate labels for all items in the database. The problem is now: we have received new items and need to generate labels just for the new ones.
Example:product id. 1, we have 5 items in stock (and labelled). We receive 5 new items of that product, so we have 10 in database, but we have to generate labels just for the 5 new.
I understand there is no direct method to do this, as quantity is an attribute in the product combination table, and you dont have separate records for every item in a combination, so I was trying to think of an method to do this. My first idea was to create a totally new and separated database (empty) create the new items there, generate de labels and then to add those items to my real database, but it does noot seem to be a very effective method.
I wonder if anayone has faced this problem and has an idea on how to do this.
Many thanks for your help!
Regards,
Rafa
I purchased Store Manager a couple of months ago. We have used it to generate product labels with barcodes and we use the integrated POS with a barcode reader in the local shop to remove products we sell in the moment.
The task to label products was easy the first time, as all products were unlabelled and we had just to generate labels for all items in the database. The problem is now: we have received new items and need to generate labels just for the new ones.
Example:product id. 1, we have 5 items in stock (and labelled). We receive 5 new items of that product, so we have 10 in database, but we have to generate labels just for the 5 new.
I understand there is no direct method to do this, as quantity is an attribute in the product combination table, and you dont have separate records for every item in a combination, so I was trying to think of an method to do this. My first idea was to create a totally new and separated database (empty) create the new items there, generate de labels and then to add those items to my real database, but it does noot seem to be a very effective method.
I wonder if anayone has faced this problem and has an idea on how to do this.
Many thanks for your help!
Regards,
Rafa
Reply
5 Answers
Jun 17, 2013
Dmytro Grycelyak
agent
wrote
Hello Rafa,
Could you please specify what do you mean by saying 'product labels' and provide us with a couple of screen captures (just for clarification), so we could check possible options for you.
Could you please specify what do you mean by saying 'product labels' and provide us with a couple of screen captures (just for clarification), so we could check possible options for you.
Jul 16, 2013
Rafa Ceres
wrote
Hello Volodymyr, thanks for your answer.
I have modified the included sample report included with the software. This report allows me to print 'labels' to stick them in out products. Each label includes product name, reference, manufacturer and reference nmber in barcode format.
Once we have generated the labels, we stick one of the to each product. In our physical store, when we sell a product, we use a barcode reader to read the reference numbre from the product and generate an order from the 'Point of sale' screen. This way, we keep the inventory updated at the moment, as products being sold in the physical store are removed from Prestashop database.
The problem is that the report tool allows us to generate reports based only in sql statements. When whe buy new amounts of a product, it is impossible to know which of them were previously existing (so the have teir sticker and there is no need to generate a new one) and which ones are new (thus, we need to generate a label). I think the example provided in my previous post is quite ilustrative.
I understand there is not a direct way to do this, as "quantity" is just an attribute in product tables and combination tables, but I was trying to imagine a bypass to do this.
Thanks!
I have modified the included sample report included with the software. This report allows me to print 'labels' to stick them in out products. Each label includes product name, reference, manufacturer and reference nmber in barcode format.
Once we have generated the labels, we stick one of the to each product. In our physical store, when we sell a product, we use a barcode reader to read the reference numbre from the product and generate an order from the 'Point of sale' screen. This way, we keep the inventory updated at the moment, as products being sold in the physical store are removed from Prestashop database.
The problem is that the report tool allows us to generate reports based only in sql statements. When whe buy new amounts of a product, it is impossible to know which of them were previously existing (so the have teir sticker and there is no need to generate a new one) and which ones are new (thus, we need to generate a label). I think the example provided in my previous post is quite ilustrative.
I understand there is not a direct way to do this, as "quantity" is just an attribute in product tables and combination tables, but I was trying to imagine a bypass to do this.
Thanks!
Jul 17, 2013
Volodymyr Hnyda
wrote
Hello Rafa,
Try the following instructions.
1. Backup the default Barcode Labels report here (copy-paste corresponding folder):
c:\Users\%username%\AppData\Local\eMagicOne Store Manager for PrestaShop\Custom_Reports\
2. In Store Manager go to Reports -> Custom Reports -> Edit "Barcode Labels" report
http://db.tt/idMrtd70
3. Click "Design Report" button
http://db.tt/HwHitAKw
4. Click on "MasterData1" label and press Ctrl+C (copy)
http://db.tt/UkFd9doT
5. Press Ctrl+V (paste) for a few times (6 per one A4 page)
6. Save the report design
http://db.tt/nWf3Oakm
7. Go to products grid and select the "newcomming" product that you want to print labels for (you may select multiple products)
8. Right-click on the selected products and go to Reports -> Barcode Labels
http://db.tt/zUIynkRu
This will print multiple barcode labels for selected products.
This is not exactly what you described - you can not control how many labels will be printed per product by "newcomming" quantity.
However, you can specify exactly what products you want to print labels for and you can print them in bulk, discarding extra labels or saving them for future.
Try the following instructions.
1. Backup the default Barcode Labels report here (copy-paste corresponding folder):
c:\Users\%username%\AppData\Local\eMagicOne Store Manager for PrestaShop\Custom_Reports\
2. In Store Manager go to Reports -> Custom Reports -> Edit "Barcode Labels" report
http://db.tt/idMrtd70
3. Click "Design Report" button
http://db.tt/HwHitAKw
4. Click on "MasterData1" label and press Ctrl+C (copy)
http://db.tt/UkFd9doT
5. Press Ctrl+V (paste) for a few times (6 per one A4 page)
6. Save the report design
http://db.tt/nWf3Oakm
7. Go to products grid and select the "newcomming" product that you want to print labels for (you may select multiple products)
8. Right-click on the selected products and go to Reports -> Barcode Labels
http://db.tt/zUIynkRu
This will print multiple barcode labels for selected products.
This is not exactly what you described - you can not control how many labels will be printed per product by "newcomming" quantity.
However, you can specify exactly what products you want to print labels for and you can print them in bulk, discarding extra labels or saving them for future.
Jul 18, 2013
Rafa Ceres
wrote
Hello Volodymyr, thanks for your help! I will have to go through your reply and try carefully... I will let you know about the results :)
I wonder it is not possible to select product combinations? Just products, including all combinations...
Many thanks!
I wonder it is not possible to select product combinations? Just products, including all combinations...
Many thanks!
Jul 19, 2013
Volodymyr Hnyda
wrote
Hi Rafa,
In order to print barcode labels for combinations you have to modify SQL statement in report to use combination details instead of product details.
In order to print barcode labels for combinations you have to modify SQL statement in report to use combination details instead of product details.