Export and Importing Products

When exporting your products from Stamp Shop Web it is important to be aware of the following steps to have a successful export and import. There are two ways to export.

Option 1:

1.) Export all products into a CSV file, leave the delimiter set to a pipe "|"

2.) Copy and paste the information into a plain text editor (something like notepad, editplus)

3.) Replace all commas within the data with a tilde ~ symbol.

4.) Replace all pipes | with commas.

5.) Save as a CSV file and open in Excel, make all your edits and save file as CSV.

6.) Open CSV file in your plain text editor program and reverse the changes we made before. First change all commas to pipes, then change all ~ to commas.

7.) Paste date into field within the import option and import products.


Option 2:

1.) Before exporting products open up the control panel on your computer.

2.) Click on "Region/Languages/Clock"

3.) Next click to change the language, and click on "additonal settings." Within this window change the "List Separator" from a comma to a pipe | and hit ok.

4.) Within the Settings tab, click on the export link within the left column. Export all products into a CSV file, leave the delimiter set to a pipe "|"

2.) Copy and paste the information into a plain text editor (something like notepad, editplus) and save as a CSV file

5.) Open in Excel, make all your edits and save file as CSV

6.) Open CSV file in your plain text editor program and copy and paste data into import field within your site. (Settings tab>Import)

7.) Import products.