Problem with importing

[brebs]

I have recently developed a problem with importing.
I am using a csv spreadsheet with just 3 columns in order to update short descriptions and prices. Column headings are Product Reference, Short Description,Price. Ever time i try to import it fails. The error message I keep getting is .... Line 2: Incompatible information in field 2 ("Price"). Expected Unknown, but got "2124". If i import the same file into the standard out of the box actinic website it works fine so it can't be the spread sheet. Has anyone encountered this problem or does anyone know how i can fix it please.

[Jan]

Do you autogenerate product references, the default store does, shouldn't make a difference but you never know do you.

Regards,

[los_design]

can you post one line of the sheet please

[brebs]

Hi Jan
No i'm not auto generating references

[brebs]

Product Reference Short Description Price
S10SPC Sapphire Square 1 Gang 250W Push Dimmer Two Way Polished Chrome 2124

[Jan]

Try it on a default site that also doesn't autogenerate product refs then, see if it then fails on there, if it does then there is something wrong with your product references.

Regards,

[brebs]

I have already tried it on a default site and it all imported fine.

[Jan]

That was my point, the default site autogenerates product references, take a default site, switch off the autogeneration of product references and see if the file still imports.

Regards,

[brebs]

Sorry yes that is what I did I turned off the outo generation on the default site and it imported fine. I then imported a snapshot of my site over the default site and I end up with the same problem. I did this to ensure that it was not my spreadsheet that was at fault. So it would appear to be the configuration on my site !

[Jan]

That's odd. Might be one for support this.

Regards,

[los_design]

Just a wild stab in the dark Paul. Have you got any hidden cells/data?

Try copying the visible data into a new spreadsheet and import that.

Just to confirm you are importing a flat file not a hierachy file?

[brebs]

Update

Actinic tech support are currently looking into this problem I will update this thread when I get the problem resolved.