X-Cart forums

[Kannan]

Hi,

How to create the new field in "xc_products" table?
Also field should reflect in the invoice page.

[tony_sologubov]

Hi!

The main process is as follows:
1) Create an empty module as described here: http://kb.x-cart.com/display/XDD/How+to+create+a+module
2) Create the file Model/Product.php script inside your module with the following content:

PHP Code:

<?php

namespace <YOUR-NAME-SPACE>;

class Product extends \XLite\Model\Product implements \XLite\Base\IDecorator
{
    /**
      * @Column(type="integer")
      */
    protected $my_int_property;

    /**
      * @Column(type="string", length="32")
      */
    protected $my_string_propery;
}

You should use your own namespace in the script, of course. Within the example, I created two properties: integer property and string one.

Once you rebuild cache X-Cart 5 will update tables and new field will appear in the database.

If you can give more details about how you want to display on invoice, I can help you with this part as well.

Tony.

[Kannan]

Hi,

Thanks. Its working. New field added in product table. We want to show that "added field value" in the invoice below the product name. Can you advice us.

Thanks in advance

[tony_sologubov]

Hi Kannan!

I will provide code sample within next two days.

Tony.

[xcartwarrior]

Hi,

Thanks. Now we added the field in invoice pages and its working. Can you advice how to show the categories and subcategories in Top menu bar like flyout menu.

Thanks in advance.

[tony_sologubov]

Hi!

First of all, you should check the last webinar doc for more details.

This section describes how you can replace menu items with your own ones:
http://kb.x-cart.com/pages/viewpage.action?pageId=7504837#Webinar2-10Apr2014-DesignchangesinX-Cart5(Custom...thmyownme nu?

Please, let me know if it helps.

Tony.

[tony_sologubov]

I have just written an article about how to accomplish task. Hopefully, it will help anybody:
http://kb.x-cart.com/display/XDD/Adding+new+property+to+product

[Phil Richman]

Based on your guide I was trying to add a product property and display it on my product page. I had no problem creating the field and storing a value in the xc product table, but when I tried to make add my .tpl so it would display on the product page I kept getting a Call to a member function get() on a non-object error. Any idea what I'm doing wrong here?

[qualiteam]

Hello Phil,

How do you display your template on the product page?

For each template file there is a PHP class that provides getSomething() methods to that template. If you do not specify such a class, it uses the class selected for the "parent" template file.

So, it looks like you display your template inside another template that doesn't have the necessary method (used in your template).

[tony_sologubov]

Hello Phil,

Could you post the code of your template here?

Thank you.

Tony

Originally Posted by Phil Richman

Based on your guide I was trying to add a product property and display it on my product page. I had no problem creating the field and storing a value in the xc product table, but when I tried to make add my .tpl so it would display on the product page I kept getting a Call to a member function get() on a non-object error. Any idea what I'm doing wrong here?