This module allows you to export categories, products, combinations, manufacturers, suppliers, customers and addresses in a csv file.
This module has been designed to get the information from a store in the simplest and easiest way possible with the main objective of importing it to another store. The format of the resulting csv file is fully compatible to be able to be imported with the importer that PrestaShop brings by default.
In the configuration of the module you can choose an entity:
- Categories
- Products
- Combinations
- Manufacturers
- Suppliers
- Customers
- Addresses
And then you can select the fields that you want to export in a csv file.
SELECTED FIELDS IN EXPORT
Categories
id_category: ID, category unique identifier.active: Category status. Values: 0 = Disabled, 1 = Enabled.name: Category name.id_parent: Parent category.is_root_category: Root category (0/1).description: Category's description.meta_title: Category meta title.meta_keywords: Category meta keywords.meta_description: Category meta description.link_rewrite: URL rewritten.image_url: Category image.id_shop_default: Shop identifier by default.
Products
id_product: ID, product unique identifier.active: Product status. Values: 0 = Disabled, 1 = Enabled.name: Product name.categories: Category list to which the product belongs separated by a comma (x, y, z ...).price_tax_excl: Product price (taxes not included).price_tax_incl: Product price (taxes included).id_tax_rules_group: Tax rule identifier for the product's price.wholesale_price: Wholesale price or product cost price.on_sale: Indicates if the product is on sale. On sale (0/1). Values: 0 = No, 1 = Yes.reference: Product reference. Reference nº.supplier: Product supplier. Supplier.manufacturer: Product manufacturer. Brand.ean13: Product EAN13 code.upc: Product UPC code.ecotax: Product ecotax.width: Product width.height: Product height.depth: Product depth.weight: Product weight.quantity: Available quantity. Quantity.mininal_quantity: Minimal quantity.visibility: Product visibility.additional_shipping_cost: Additional shipping cost for the product.unit_price_ratio: Product unit price.description_short: Product short description.description: Product description.tags: Tags (x, y,z…).meta_title: Product’s meta title.meta_keywords: Product meta keywords.meta_description: Product meta description.link_rewrite: URL rewritten.available_now: Text when in stock.available_later: Text when backorder allowed.available_for_order: Available for order (0 = No, 1 = Yes).available_date: Product availability date.date_add: Product creation date.show_price: Show price (0 = No, 1 = Yes).url_images: Image URLs (x,y,z...).features: Features (Name:Value:Position:Customized).online_only: Available online only (0 = No, 1 = Yes).condition: Product condition. Available values:customizable: Customizable (0 = No, 1 = Yes).uploadable_files: Uploadable files (0 = No, 1 = Yes).text_fields: Text fields (0 = No, 1 = Yes).out_of_stock: Action when out of stock.
Combinations
id_product: Product ID, product unique identifier.product_reference: Product reference.attribute: Attribute (Name:Type:Position)*.value: Value (Value:Position)*.reference: Reference.ean13: Combination EAN13 code.upc: Combination UPC code.wholesale_price: Wholesale price.price: Impact on price.unit_price_impact: Impact on unit price.ecotax: Ecotax.quantity: Available quantity.mininal_quantity: Minimal qunatity.default_on: Default (0 = No, 1 = Yes).available_date: Combination availability date.image_url: Image URLs (x,y,z...).
Manufacturers or brands
id_manufacturer: ID, manufacturer unique identifier.active: Manufacturer status. Values: 0 = Disabled, 1 = Enabled.name: Manufacturer name.description: Manufacturer description.short_description: Manufacturer short description.meta_title: Manufacturer meta title.meta_keywords: Manufacturer meta keywords.meta_description: Manufacturer meta keywords.image_url: Image URL.id_shop: Shop identifier.
Suppliers
id_supplier: ID, supplier unique identifier.active: Supplier status. Values: 0 = Disabled, 1 = Enabled.name: Supplier name.description: Supplier description.meta_title: Supplier meta title.meta_keywords: Supplier meta keywords.meta_description: Supplier meta description.image_url: Image URL.id_shop: Shop identifier.
Customers
id_customer: ID, customer unique identifier.active: Customer status. Values: 0 = Disabled, 1 = Enabled.id_gender: Titles ID (Mr = 1, Ms = 2, else 0).email: Email*.passwd: Encrypted password*.birthday: Birthday (dd-mm-aaaa).lastname: Last name*.firstname: First name*.newsletter: Newsletter (0/1).optin: Opt-in (0/1).date_add: Customer registration date.groups: Groups (x,y,z...).id_default_group: Default group ID.
Addresses
id_address: ID, address unique identifier.alias: Address Alias*.active: Address status. Values: 0 = Disabled, 1 = Enabled.email: Customer email *.id_customer: Customer ID.manufacturer: Manufacturer.supplier: Supplier.company: Company.lastname: Last Name *.firstname: First Name *.addres1: Address 1 *.addres2: Address 2.postcode: Zip/postal code *.city: City *.country: Country *.state: State.other: Other.phone: Phone.phone_mobile: Mobile phone.vat_number: VAT number.dni: DNI/NIF/NIE.
