Import \ Export Produkte und Kategorien

Phoca Cart - complex e-commerce extension
Wormtronic
Phoca Newbie
Phoca Newbie
Posts: 2
Joined: 01 May 2016, 23:48

Import \ Export Produkte und Kategorien

Post by Wormtronic »

Hallo,
gibt es auch eine Import \ Export Funktion, mit der man Tabellen mit Kategorien oder Produkten importieren oder erzeugen kann?
Gruß Wormtronic
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 47810
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Import \ Export Produkte und Kategorien

Post by Jan »

Hallo, der beste Weg für Import/Export is phpMyAdmin, da kann man mehrere verschiedenen Formats für Import/Export wählen. z.B. CSV:

Code: Select all

"8","3","1","3","Audi A8","audi-a8",,,"97000.0000","99000.0000","0.0000","0.0000","0.0000","0","0.0000","0","0.0000","0","0","0.0000",,"0","2","0",NULL,"222111555",,,,,,,,,,,,"Audi/A8/a8-facelift.png",,"0","0",NULL,"252d603b5556a14bc82f19a1e62c0dc89e824a43399b659858d61dc9edf53c64","b9028a3d8d949f6c",,"0","1","0","0000-00-00 00:00:00","2","1","2014-04-18 12:32:00","0","0",NULL,,,NULL,"*"
"9","3","1","3","Audi S3","audi-s3",,,"83000.0000","85000.0000","0.0000","0.0000","0.0000","0","0.0000","0","0.0000","0","0","0.0000",,"0","2","0",NULL,"222111555",,,,,,,,,,,,"Audi/S3/audi-s3.png",,"0","0",NULL,"de02e677b05fa8427ee746ab1fdae54b226ba05245abf17b2a80c46dc14039bf","6ee1d8c44b07f46c",,"0","1","0","0000-00-00 00:00:00","3","1","2014-04-18 12:33:33","0","0",NULL,,,NULL,"*"
oder php array:

Code: Select all

array('id'=>'9','catid'=>'3','tax_id'=>'1','manufacturer_id'=>'3','title'=>'Audi S3','alias'=>'audi-s3','description'=>'','description_long'=>'','price'=>'83000.0000','price_original'=>'85000.0000','length'=>'0.0000','width'=>'0.0000','height'=>'0.0000','unit_size'=>'0','weight'=>'0.0000','unit_weight'=>'0','volume'=>'0.0000','unit_volume'=>'0','stock'=>'0','unit_amount'=>'0.0000','unit_unit'=>'','min_quantity'=>'0','stockstatus_a_id'=>'2','stockstatus_n_id'=>'0','availability'=>NULL,'sku'=>'222111555','upc'=>'','ean'=>'','jan'=>'','isbn'=>'','mpn'=>'','serial_number'=>'','registration_key'=>'','external_id'=>'','external_key'=>'','external_link'=>'','external_text'=>'','image'=>'Audi/S3/audi-s3.png','video'=>'','featured'=>'0','allow_upload'=>'0','custom_text'=>NULL,'download_token'=>'de02e677b05fa8427ee746ab1fdae54b226ba05245abf17b2a80c46dc14039bf','download_folder'=>'6ee1d8c44b07f46c','download_file'=>'','download_hits'=>'0','published'=>'1','checked_out'=>'0','checked_out_time'=>'0000-00-00 00:00:00','ordering'=>'3','access'=>'1','date'=>'2014-04-18 12:33:33','hits'=>'0','sales'=>'0','params'=>NULL,'metakey'=>'','metadesc'=>'','metadata'=>NULL,'language'=>'*') 
Jan
If you find Phoca extensions useful, please support the project
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 47810
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Import \ Export Produkte und Kategorien

Post by Jan »

Oder XML:

Code: Select all

</table>
        <table name="jos_phocacart_products">
            <column name="id">9</column>
            <column name="catid">3</column>
            <column name="tax_id">1</column>
            <column name="manufacturer_id">3</column>
            <column name="title">Audi S3</column>
            <column name="alias">audi-s3</column>
            <column name="description"></column>
            <column name="description_long"></column>
            <column name="price">83000.0000</column>
            <column name="price_original">85000.0000</column>
            <column name="length">0.0000</column>
            <column name="width">0.0000</column>
            <column name="height">0.0000</column>
            <column name="unit_size">0</column>
            <column name="weight">0.0000</column>
            <column name="unit_weight">0</column>
            <column name="volume">0.0000</column>
            <column name="unit_volume">0</column>
            <column name="stock">0</column>
            <column name="unit_amount">0.0000</column>
            <column name="unit_unit"></column>
            <column name="min_quantity">0</column>
            <column name="stockstatus_a_id">2</column>
            <column name="stockstatus_n_id">0</column>
            <column name="availability">NULL</column>
            <column name="sku">222111555</column>
            <column name="upc"></column>
            <column name="ean"></column>
            <column name="jan"></column>
            <column name="isbn"></column>
            <column name="mpn"></column>
            <column name="serial_number"></column>
            <column name="registration_key"></column>
            <column name="external_id"></column>
            <column name="external_key"></column>
            <column name="external_link"></column>
            <column name="external_text"></column>
            <column name="image">Audi/S3/audi-s3.png</column>
            <column name="video"></column>
            <column name="featured">0</column>
            <column name="allow_upload">0</column>
            <column name="custom_text">NULL</column>
            <column name="download_token">de02e677b05fa8427ee746ab1fdae54b226ba05245abf17b2a80c46dc14039bf</column>
            <column name="download_folder">6ee1d8c44b07f46c</column>
            <column name="download_file"></column>
            <column name="download_hits">0</column>
            <column name="published">1</column>
            <column name="checked_out">0</column>
            <column name="checked_out_time">0000-00-00 00:00:00</column>
            <column name="ordering">3</column>
            <column name="access">1</column>
            <column name="date">2014-04-18 12:33:33</column>
            <column name="hits">0</column>
            <column name="sales">0</column>
            <column name="params">NULL</column>
            <column name="metakey"></column>
            <column name="metadesc"></column>
            <column name="metadata">NULL</column>
            <column name="language">*</column>
        </table>
    </database>
</pma_xml_export>
If you find Phoca extensions useful, please support the project
Post Reply