After you have added a new language (incl. default currency, if needed) and created a new subshop, you can import products into this subshop.

sign_warning

Important

Before you import or re-import products, we highly recommend that you do a database backup using HeidiSQL.
Make sure each shop has a unique subshop ID, and tell us this ID, so we can unlock the shop for the 3P SetupWizard and 3P Publisher applications.
If you import a products.xml file into a subshop, which has a different language than the 3P Demo shop (default, English), then at first you won't be able to see these products in the OpenCart Administration. You have to change the Administration > System > Settings > Default Shop > Administration Language of the default EN store to your new language, in order to see the products & options of the new language. On the other hand, if you install two stores with same language (the default language), you will see the products of both stores in the OpenCart Administration.

The product importer can be found under Administration > System > Products Importer. Please be aware, that all products and product features must be defined in the products.xml file only. If you change any product options in the OpenCart Administration interface, they will be overwritten the next time you import the products.xml file.

If you need to change prices, deactivate products and add new products or new product features, do this only by means of XML editor inside the products.xml file. After every change, you need to re-import the file into the corresponding shop. Make sure to import the right products.xml file for each shop. Its generally a good idea to make a database backup before you re-import a products.xml file. A product import will not destroy any existing orders, but if you import the wrong file, you will certainly mess up your order records.

admin_oc6

Product Categories

Product categories (groups) and tags (keywords for the Tag Cloud) are imported from the <PRODUCTGROUPS> section of the products.xml. Read the next chapter for details on this.
 

Product Features (Options)

The product features in the screenshots below originate from the Red attributes of the products.xml. Please do not change them in the OpenCart Administration! The attributes marked in Blue are used to calculate the Page Increment (Matt): +8 pages option. For more infos, read the chapter on Paper Pricing.

lightbulb_onThe VAT is automatically deducted from the feature price and later added again in the order item.
 

   <BasePrice>16950</BasePrice>

   <VAT>700</VAT>

   <CHUNKS>

     <CHUNK title="content">

       <Fixed>0</Fixed>

     <BasePageCount>16</BasePageCount>

      <PageIncrement>8</PageIncrement>

       <MaxPageCount>120</MaxPageCount>

       <UpPriceInc>1800</UpPriceInc>

     </CHUNK>

   </CHUNKS>

   <FEATUREGROUPS>

     <FEATUREGROUP>

       <Name>Header Paper</Name>

       <FEATURE selected="1">

         <Name>Standard</Name>

         <DisplayName>White</DisplayName>

       </FEATURE>

       <FEATURE selected="0">

         <Name>Black</Name>

         <DisplayName>Black</DisplayName>

         <UpPrice>250</UpPrice>

       </FEATURE>

     </FEATUREGROUP>

     <FEATUREGROUP>

       <Name>Cardboard</Name>

       <FEATURE selected="1">

         <Name>Not padded</Name>

         <DisplayName>Not padded</DisplayName>

       </FEATURE>

       <FEATURE selected="0">

         <Name>Padded</Name>

         <DisplayName>padded</DisplayName>

         <UpPrice>2500</UpPrice>

       </FEATURE>

     </FEATUREGROUP>

     <FEATUREGROUP>

       <Name>Cover coating</Name>

       <FEATURE selected="1">

         <Name>Foiled glossy</Name>

         <DisplayName>Glossy</DisplayName>

       </FEATURE>

       <FEATURE selected="0">

         <Name>Foiled matt</Name>

         <DisplayName>Matt</DisplayName>

        <PageUpPrice>1000</PageUpPrice>

         <UpPrice>1800</UpPrice>

       </FEATURE>

     </FEATUREGROUP>

 

option_all_possibility

lightbulb_onIf you want the feature to display a different name, then set the <DisplayName> in addition to the <Name> tag in the products.xml file. If neither <Name> or <DisplayName> are given, then the feature is used to show an additional informative product image by means of the <ImageFile> tag. The image is displayed in the options page of the Publisher Product Wizard, and in the product description of the 3P OpenCart store. The feature itsself is not shown in the list of available product features of the store. If you set visible="0", then the image is only displayed in the store product description.

     <FEATUREGROUP>

        <Name>Hardcover</Name>

        <FEATURE selected="1" visible="1">

          <ImageFile>images\dx011_hard.jpg</ImageFile>

        </FEATURE>

      </FEATUREGROUP>

lightbulb_onSee Products.xml for a more detailed description of the XML tags.
 

admin_oc7

 

Product Images

All product images from a subshop should be copied to the folder C:\inetpub\wwwroot\opencart\image\data\3p_products\<subshop>. If the shop needs to display product and category images in a higher resolution than the Publisher, you have two alternatives:

1.In the OC Administration, change the Catalog > Categories > Data > Image and Catalog > Products > Data > Image names. The names will not be overwritten next time you import a new products.xml.
2.Replace the files in the folder above. This is probably the easier alternative.

 

Product Filters

The Price filter is taken from the BasePrice attributes, and the Size filter from the Format attributes of the products.xml file:

  <PRODUCT id="dx011001" active="1" selected="0" groupid="dx011">

    <LongName>Hardcover 14,8 cm x 21,0 cm</LongName>

    <ShortName>14,8 cm x 21,0 cm (A5 hoch)</ShortName>

   <FormatWidth>14,8 cm</FormatWidth>

   <FormatHeight>21,0 cm</FormatHeight>

    ...

    <BasePrice>15600</BasePrice>

 

The filter range itsself is defined through the following section (in an example of the of 3P Demo shop). Depending on your currency you will have to adjust these values in the products.xml. You can add any filter to the Price or the Size list. The last entry will show all remaining products more expensive or bigger than the previous value (example: Big Sizes).
sign_warningIf you have several subshops (and corresponding products.xml files) in different languages, make sure the Name tag stays the same over all languages - just translate the DisplayName tags:

<FILTERS name="Price" displayname="Price">

    <FILTER>

        <Name>All Prices</Name>

        <DisplayName>All Prices</DisplayName>

        <Min>0</Min>

        <Max>1000000</Max>

    </FILTER>

    <FILTER>

        <Name>&lt; 20</Name>

        <DisplayName>&lt; 20</DisplayName>

        <Min>0</Min>

        <Max>20</Max>

    </FILTER>

    <FILTER>

        <Name>20 .. 30</Name>

        <DisplayName>20 .. 30</DisplayName>

        <Min>20</Min>

        <Max>30</Max>

    </FILTER>

    ...

</FILTERS>

<FILTERS name="Size" displayname="Size">

    <FILTER>

        <Name>All Sizes</Name>

        <DisplayName>All Sizes</DisplayName>

        <Width>0</Width>

        <Height>0</Height>

    </FILTER>

    <FILTER>

        <Name>Square</Name>

        <DisplayName>Square</DisplayName>

        <Width>0</Width>

        <Height>0</Height>

    </FILTER>

    <FILTER>

        <Name>A5 Sizes</Name>

        <DisplayName>A5 Sizes</DisplayName>

        <Width>148</Width>

        <Height>210</Height>

    </FILTER>

    ...

    <FILTER>

        <Name>Remaining</Name>

        <DisplayName>Big Sizes</DisplayName>

        <Width>9999</Width>

        <Height>9999</Height>

    </FILTER>

</FILTERS>

 

Flipbook Preview

The Flipbook page thumbs are only created and uploaded by the 3P Publisher if you add the following to the products.xml:

<PageThumbnails enabled="1" maxwidth="600" maxheight="600">JPG</PageThumbnails>

 
The flipbook can be launched by the customer from the shopping cart and the order history form.

 

lightbulb_on

Other attributes

Tax Classes are created for every tax from the products.xml. Examples: <VAT>1900</VAT> = 19%, <VAT>0700</VAT> = 7%
All prices in the products.xml are including tax, but in the table oc_product the prices are stored without tax.
Discounts: <REBATES> for higher order amounts are also imported from the products.xml.

2015 © 3P Photobook Publisher