Importing CSV Files ShopperPress
O Autor do ShopperPress mostra como efectuar a importação de dados de um carrinho de compras para a solução e-commerce desenvolvida por ele.
A seguir seguem-se os passos necessários para a importação.
O texto seguinte está exactamente como no site do ShopperPress e pode ser seguido directamente no site.
Quick Introduction
The CSV file or excel spreadsheet stores product information allowing you to download saved datafeeds and import them quickly into your wordpress shopping cart.
All you need to Remember
All you need to remember is that the FIRST row of your CSV file must contain the column headers and if you want them to be import into the wordpress fields RATHER than the custom fields you must rename the headers to match the wordpress database column name.
Example
If in your CSV file you have a column header called ‘Product Description’ and this column contains the product descriptions you MUST rename this to the wordpress database name IF you want it to appear in the wordpress description fields.
If you DO NOT rename the column header, it will be added as a custom field and keep the existing column name value.
Here is a list of wordpress database column headings;
Key Headings
post_title
post_excerpt
post_content
Other possible wordpress headings
post_author
post_date
post_date_gmt
post_status
comment_status
ping_status
post_password
post_name
to_ping
pinged
post_modified
post_modified_gmt
post_content_filtered
post_parent
guid
menu_order
post_type
post_mime_type
comment_count
Bascially….
If you have a column in your CSV file that you want to be used as the title for your product within your shopping cart website, simply RENAME the current heading to ‘post_title’.
Same with content, if you have a description column, rename the column header to ‘post_content.
Custom Fields
If your heading isnt found within the list above it will automatically be added as a custom field, i would recommend you use the field names below for extra custom fields such as prices, images etc.