Proper attributes format in Excel document, to prepare to import into new PrestaShop Database?

[Damainman]

This is a brand new Presta Installation, and I'm trying to figure out how to format the csv export file I made from my current point of sale software.

I haven't setup the product or attributes or anything in my database yet... because I'm trying to figure out what work I need to do before I even attempt to import my products.

---
Lets say I have an Excel sheet with a column representing every accepted field for PrestaShop. (The listed required/optional fields it shows in the BO when importing). I have a two part question

Part 1
Now lets say I sell Pepsi.

I sell:
1 can = $0.99
6 Pack = $4.99
12 Pack = $11.99
24 Pack = $20.99

What column should all this be in, and how exactly should it look in the column/columns that it's in?

Also if lets say I also sold Diet Pepsi, would this be considered a completely different product or is there a way that when someone goes to the pepsi product page, they can choose regular or diet?
-------
Part 2

Now lets also say I sell gum:
1 stick = $0.25
12 Pack = $1.00
24 Pack = $2.00

But I sell different flavors(all the same price)
Cherry
Grape
Apple
Watermelon
Orange

What column should all this be in, and how exactly should it look in the column/columns that it's in?
------------

I'm open to all suggestions and comments, so if you think i'm going about this the wrong way then I'm open ears .

Thank you in advance for your reply.

[rocky]

To do this from the Back Office in PrestaShop is quite easy. You can create one pepsi product with an attribute group called "Type" with attributes "Regular" and "Diet" and another attribute group called "Pack" with attributes "1", "6", "12" and "24. You can then use the Product Combinations Generator on the "3. Combinations" tab of the product editor to enter the price differences from the base price. You can enter price differences of 0 for attributes like "Flavor" that don't affect the price.

The problem is that PrestaShop doesn't support importing attributes, only combinations. So you'd have to manually generate all the combinations of price differences yourself and put each one in a row of the CSV instead, which is difficult to manage unless you design a tool to do it for you. Also, the combinations import doesn't let you assign images to individual combinations like you can do with the "3. Combinations" tab.

How many products do you expect to be importing? Would it be unmanageable to create each product one-by-one in the Back Office?

[Damainman]

Thank you for taking the time to reply Rocky.

I'm using a sort of out dated version of WASP, which is a barcode scanner which integrates into my point of sale. It's very limited as it doesn't let me insert custom fields and has one csv export with no options to choose anything specific.

My dilemma is 4 parts really:
1. I have over 3,000 products I need to import into PrestaShop.
2. I have hundreds of items that change in price on a daily basis.
3. I provide same day delivery so I can't sell items which are out of stock in my physical store.
4. Things that would be in the Presta Shop as attributes like a 6 pack of pepsi is actually exported from my software as a separate product. So 1 can of pepsi a 6 pack of pepsi is actually exported as two completely separate products instead 1 product with several variations.

Because of this I will need to export all the products everyday at midnight when the store closes, and import them into PrestaShop to prepare for the next day. This is to update the price changes and stock quantity of my Presta Shop on a nightly basis to match my store.

The WASP software doesn't allow me to choose specific products to export, it just does a full dump and exports all products.

I have an idea on how to manage the data via a spreadsheet which I will convert into csv and make it utf-8. But using a spreadsheet, I need a better understanding on how to format the data into the columns, so it imports correctly.
--

In the pepsi attribute example you gave, I have no problem going into the BO to create the initial attribute groups and values. But lets say:
1. I created an attribute group called Pack with 1,6,12, and 24.
2. Each attribute 1,6,12, and 24 .. has different prices

When RE-importing products such as Pepsi into my store because lets say there was a change in the price. How would I go about updating the prices for the 1,6,12, and 24 attributes... or is there no way to update attribute prices?

Thank you again in advance.

[rocky]

You can re-import the combinations CSV with different prices and PrestaShop v1.3 should replace the existing combinations with those ones. PrestaShop v1.2.5 had a bug where all the combinations were added a second time instead of updated. It might be easier for you to not use attributes though if your WASP software can only export the products separately.

[[PrestaModule] JS]

Here is a free module export attributes.

http://en.presta-module.com/22-export/attribute/module.html

Enjoy

[SonnyBoyII]

You can re-import the combinations CSV with different prices and PrestaShop v1.3 should replace the existing combinations with those ones. PrestaShop v1.2.5 had a bug where all the combinations were added a second time instead of updated. It might be easier for you to not use attributes though if your WASP software can only export the products separately.

Do u know any solution for this problem??
I'd like to reimport some attributes just to re-write new price impact ...
It seems that Presta Version 1.3.3.0 still has the issue... rubbish...

[SonnyBoyII]

help ... please...
How can I fix prestashop import module ??