Import unique Product ID for Combinations

[redstyles]

Hi,

I'm trying to figure out how to associate combination for products without using the internal database assigned product id #.

I have this for example of a product import : SWP1119,FIVE POCKET PANTS,WOMENS,110,SECOND,1


I would like the SWP1119 to be the product ID, not what Presta assigns (in this case it was 310)

My combination would then look something like this:

SWP1119;color:INK,size:25;SWP1119-INK-25;1;1

SWP1119;color:INK,size:26;SWP1119-INK-26;1;0


SWP1119;color:INK,size:26;SWP1119-INK-26;1;0

But it only accepts the pre-assigned one so it would look like this in order to work

310;color:INK,size:25;SWP1119-INK-25;1;1

310;color:INK,size:26;SWP1119-INK-26;1;0


310;color:INK,size:27;SWP1119-INK-27;1;0

What am I missing? How, without knowing the exact Presta ID can I associate the two?
A big thanks for any help I can get.... it's appreciated.

[Kelvin Koh]

Presta ID is the unique method how Prestashop identifies a specific product, so we can't change that. It's how it links a product to all it's other info/details.

However, you can link your Product ID (usually referred to or known as SKU), eg SWP1119, in the Reference field in the Products Info. See the red box in 1st attached image.

You can put SKUs for that particular product's sizes (25, 26), eg SWP1119-INK-25 in the particular combination's Reference field. See red box in 2nd attached image.

[redstyles]

Thank you for the quick and detailed response, it's very appreciated

My issue is that I'm exporting all the information from a POS systems database and parsing the information. I'm trying to automate the uploading of products and attributes as much as I possibly can. From the data, I make a Products sheet and Combinations sheet in Excel that I save as CSV (which I also have an issue with for a later time) that would be uploaded to Presta.

The example above of the combinations with the SKU is really all I have, there's no way to reference the Pesta Product ID and it's a required field and by the looks of it I need it to be able to perform the upload

This is really frustrating me and would love a solution.. thanks

[Kelvin Koh]

Thank you for the quick and detailed response, it's very appreciated

My issue is that I'm exporting all the information from a POS systems database and parsing the information. I'm trying to automate the uploading of products and attributes as much as I possibly can. From the data, I make a Products sheet and Combinations sheet in Excel that I save as CSV (which I also have an issue with for a later time) that would be uploaded to Presta.

The example above of the combinations with the SKU is really all I have, there's no way to reference the Pesta Product ID and it's a required field and by the looks of it I need it to be able to perform the upload

This is really frustrating me and would love a solution.. thanks

Here's my suggested solution. It's going to be a bit long, so please be patient.

Step 1: Download OpenOffice
I understand you have some issues with Excel saving files as CSV. I recommend you use OpenOffice Calc instead. It's the same as Excel, except that it's more user-friendly when it comes to saving files as CSV and reading/opening CSV files.

Step 2: Download & implement Inventory Management mod
To help you with keeping track of your inventory as well as acquiring Presta IDs, implement the Inventory Management modification. Download the 3 files and follow the instructions. With this mod, you can download a CSV file with Presta IDs, Reference (your SKU), Product Name etc.

Step 3: Create your Products OpenOffice/Excel and CSV files
Create your Products OpenOffice/Excel and CSV files. You don't need to worry about Presta IDs at this point of time. Prestashop will create the IDs automatically for you. Leave out the combinations at this point. You don't need them yet. Just the main Product will do, eg FIVE POCKET PANTS. Don't forget to include your products' SKUs in the Reference field.

Step 4: Import your Products
Upload your Products CSV file. Import your Products from BO >> Tools >> Import.
The main Products details will be imported and created in your BO >> Catalog. At this point, Presta IDs will also be created and assigned to your products.

Step 5: Download your Inventory CSV file
Go to your newly created BO >> Inventory >> Inventory tab/page. Here, you can see your inventory along with all their IDs. Scroll to the bottom of the page. Download the CSV.

Step 6: Edit the Inventory CSV into Combinations
a) Open your downloaded Inventory CSV using OpenOffice Calc. Save the file as ODF Spreadsheet (.ods) file.
Edit the spreadsheet for your Combinations. Now you have Presta IDs & SKUs for all your main Products, editing this file by inserting combinations and changing fields will be easy.
c) After editing, save file as CSV encoded in UTF-8. Use ; as Field seperator and , as Multiple value separator.

Step 7: Import your Combinations
Upload your Combinations CSV file. Import your Combinations from BO >> Tools >> Import.
Now all the products' combinations will be added to your products in the catalog.

You're done! You can go to your BO >> Catalog or BO >> Inventory >> Inventory tab/page to check.

AdminInventory.php

AdminInventoryReports.php

Instructions.txt

[redstyles]

Thanks calisyoda.... If only all of life's questions were answered this thoroughly.

I'm going to give this a try, much appreciated

[bruce-rez]

I uploaded the files in my Admin/Tabs folder and then I did the below steps:
[1] Upload the AdminInventory.php and AdminInventory.php files to your admin/tabs folder.

[2] Go to the admin section then click on “Tools” then click “Tabs”. Click on “Add new”

but I cannot see the the Tabs in Tools page. I use PrestaShop™ 1.4.0.14.
Thanks for any help.
See the screen shot.

[Kelvin Koh]

In Prestashop 1.4, Tabs is moved to Employees as shown in the image in attached.

[bruce-rez]

Thanks calisyoda,
I found it.

[jincmd]

 

 

Here's my suggested solution. It's going to be a bit long, so please be patient.

 

Step 1: Download OpenOffice

I understand you have some issues with Excel saving files as CSV. I recommend you use OpenOffice Calc instead. It's the same as Excel, except that it's more user-friendly when it comes to saving files as CSV and reading/opening CSV files.

 

Step 2: Download & implement Inventory Management mod

To help you with keeping track of your inventory as well as acquiring Presta IDs, implement the Inventory Management modification. Download the 3 files and follow the instructions. With this mod, you can download a CSV file with Presta IDs, Reference (your SKU), Product Name etc.

 

Step 3: Create your Products OpenOffice/Excel and CSV files

Create your Products OpenOffice/Excel and CSV files. You don't need to worry about Presta IDs at this point of time. Prestashop will create the IDs automatically for you. Leave out the combinations at this point. You don't need them yet. Just the main Product will do, eg FIVE POCKET PANTS. Don't forget to include your products' SKUs in the Reference field.

 

Step 4: Import your Products

Upload your Products CSV file. Import your Products from BO >> Tools >> Import.

The main Products details will be imported and created in your BO >> Catalog. At this point, Presta IDs will also be created and assigned to your products.

 

Step 5: Download your Inventory CSV file

Go to your newly created BO >> Inventory >> Inventory tab/page. Here, you can see your inventory along with all their IDs. Scroll to the bottom of the page. Download the CSV.

 

Step 6: Edit the Inventory CSV into Combinations

a) Open your downloaded Inventory CSV using OpenOffice Calc. Save the file as ODF Spreadsheet (.ods) file.

Edit the spreadsheet for your Combinations. Now you have Presta IDs & SKUs for all your main Products, editing this file by inserting combinations and changing fields will be easy.

c) After editing, save file as CSV encoded in UTF-8. Use ; as Field seperator and , as Multiple value separator.

 

Step 7: Import your Combinations

Upload your Combinations CSV file. Import your Combinations from BO >> Tools >> Import.

Now all the products' combinations will be added to your products in the catalog.

 

You're done! You can go to your BO >> Catalog or BO >> Inventory >> Inventory tab/page to check.

 

 

thanks. I would like to try this, has it been tested in v1.5?