Import Products

[chris ashdown]

Good morning all

Starting a new site and all product details come in excel .csv format

Looking for the right headers to match sellerdeck for the following

ref no
description
name
Cost price
Sell price
weight
size
vat rate
Section
Sub section

Next part

How do you add to text files together in excel so for instance B2(hello) +b3(there) =b4(Hello there)

In V12 what are the new Themes?

[NormanRouxel]

Excel: This is known as concatenation (concatenate in the Help) and uses the & operator:

=B2&" "&B3

Note the space. Assuming you want Hello there, not Hellothere.

Themes: Some have been tweaked and renamed. Have a look using the demo site.

[chris ashdown]

Thank you Norman

[mash]

ref no - Product Reference
description - Full description
name - Short description
Cost price - nCostPrice this may be Cost Price
Sell price - Price

vat rate - Tax Treatment
Section - Section Text (sub section separate by "|" like Plug Plants|Week 15|Lettuce)

I use Text Tab delimited works well.

Hope that helps, thanks M

[NormanRouxel]

If I recall correctly, SD expects the prices to be in pennies. So you may need a new column in Excel that's the manufacturer supplied one times 100.

[jont]

If I recall correctly, SD expects the prices to be in pennies.

It does, and it will throw up a big warning during the import routine as well with a click to confirm they are formatted in pennies to continue

[Paul Bulpit]

Excel: This is known as concatenation (concatenate in the Help) and uses the & operator:

Well I never! I don't suppose there's a way of unconcatenating?

We need to transfer our V9 Customer Records into V10 & later, which use two fields (First Name) & (Last Name) for the previous one field (First Name Last Name).

The file imports OK, until you actually open a record - they're Required Fields. We think we'll just have to trawl down the column in Access typing them all in.

What happens with this when you simply upgrade from V9 to a later version?
______
Paul

[mash]

Well I never! I don't suppose there's a way of unconcatenating?

You can Split names by using the Convert Text to Columns Wizard, may save you typing it in again - See example

[chris ashdown]

Thanks all, Great help

Anyone know a quick way of reducing 5000 jpg's to reduced size and dpi, I have Photoshop elements which can do it in about a maximum of 50 jpg 's a time but a long haul it that rate

[jont]

There are plenty of free image batch image converters out there eg http://sourceforge.net/projects/dinoimages/ which should do the trick

[jont]

ps - I have not tried the above software

[Duncan Rounding]

FastStone Photo Resizer is what I use for quick batching. Does most things I need.