Questions tagged [prefix]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
1 answer
60 views

How to replace the '+' prefix in customizable options value string

Anyone knows where this + prefix symbol in customizable options is coming from? I'd like to replace it with something like "for {price}". I searched all over Magento modules and couldn't ...
kray's user avatar
  • 3
0 votes
3 answers
510 views

Magento 2 How change ID for order?

I have order with ID = 00000188 UPDATE `sales_sequence_profile` SET `prefix` = '9' WHERE `sales_sequence_profile`.`profile_id` = 1; And now my order ID = 900000188 But I want change to this format ...
David Young's user avatar
1 vote
1 answer
282 views

Magento 2.3 prefix admin not displayed as dropdown

We use the default customer Show Prefix method. This works fine on the frontend. But in the admin panel, the prefix in the customer is displayed as a input open text field, not as a dropdown with the ...
JGeer's user avatar
  • 1,418
0 votes
3 answers
1k views

Table prefix error when running - setup:db-declaration:generate-whitelist

I've run the command php bin/magento setup:db-declaration:generate-whitelist --module-name={Vendor_Module} and receive the following error... Magento was installed with a table prefix. Please re-...
Eddie's user avatar
  • 139
2 votes
0 answers
35 views

Magento2 : Change Customer name Prefix to Radio button from Dropdown on Checkout page, cant be at the Osc for mageplaza billing address

need to the Change Customer name Prefix to Radio button from Dropdown on the checkout page I followed this solution Magento2 : Change Customer name Prefix to Radio button from Dropdown on Checkout ...
Robert Baum's user avatar
1 vote
1 answer
213 views

How does one get the order prefix programmatically?

We use separate order prefixes for our production and lower environments. For each environment we run a sequel statement to update so each environment is unique. update `sales_sequence_profile` set ...
guerinteed_mike's user avatar
0 votes
1 answer
505 views

How to Remove Prefix & Suffix from admin Customer Account Magento 1

I want to remove Prefix and Suffix from the Customer Information tab in the admin section. Can any tell me how to remove both from the admin customer tab? Thanks.
Nikul's user avatar
  • 1,306
1 vote
0 answers
176 views

how to remove customer prefix and suffix from paypal and credit card- magento 1.9

How i can to remove prefix and suffix from heading payment paypal and credit card. Thanks!
alessandro's user avatar
0 votes
2 answers
330 views

Magento 2: 2 databases, only one with table_prefix

I have defined an additional custom database connection in etc/env.php: 'db' => [ 'table_prefix' => 'abc_', 'connection' => [ 'default' => [ 'host' => '...
omsta's user avatar
  • 698
1 vote
1 answer
525 views

Magento 2.3 prefix radio button

I want to change the default prefix select box to a radio select box. Therefore I added the following module, but it is not changing the select to radio. What am I missing here? /app/code/VendorName/...
JGeer's user avatar
  • 1,418
1 vote
0 answers
279 views

Error after removing database Prefix

I am in the process of upgrading our Magento 2.2.5 website to version 2.3. I have managed to do this and the website works fine, as far as I can tell. However, we have a third party extension for a ...
user73594's user avatar
0 votes
0 answers
179 views

I need to create a new module to table exists with another prefix of mam

I need to create a new module and this project have tables with other prefixes, How I omit this default prefix in my file /Model/ModelTable.php this is the code inside: namespace Arkix\Zonas\Model\...
andrwsv's user avatar
1 vote
0 answers
185 views

M2 Confirmation Mail: prefix won't translate

Customers are saved in the DB with prefix "Mr." or "Mrs.". Registration Confirmation Email Template looks like this {{template config_path="design/email/header_template"}} <p class="greeting">...
Eric Seidler's user avatar
0 votes
2 answers
1k views

Magento 2 get database prefix on install data

How to get database table prefix on install data? It is showing "table or view not found". <?php namespace ...; use Magento\Eav\Setup\EavSetupFactory; use Magento\Framework\Setup\...
akshay billore's user avatar
4 votes
2 answers
7k views

How to change the order number's prefix of a specific store, Magento2

Magento2.2.4, php7; I have multiple stores where I want each one of them to have a different order number's prefix. Is there anyway to realize that? Thanks! Edit: I'm trying to avoid using raw ...
Mariam Ghalleb's user avatar
1 vote
2 answers
981 views

checkout_agreement_store doesn't exist

Any idea? Preconditions Starting from Magento CE 2.2.5 Upgrade from 2.2.5 to 2.2.6 Steps to reproduce Starting from Magento CE 2.2.5 Created a terms and conditions (Store-->Terms and conditions) ...
Michele's user avatar
  • 33
1 vote
1 answer
58 views

Magento 1.9 : I have a very strange Magento problem

Error : SQLSTATE[42S02]: Base table or view not found: 1146 Table 'i1115580_mg3.sales_flat_shipment_track' doesn't exist Query: SELECT track_number FROM sales_flat_shipment_track
user71370's user avatar
2 votes
1 answer
1k views

Magento 2 Get table name with prefix

I'm trying to get a table name with prefix. I currently try to use getConnection()->getTableName() but that doesn't work. I've seen people suggesting to use $this->_resource->getTableName() ...
Roman's user avatar
  • 51
1 vote
1 answer
2k views

How to get table prefix?

I have the following code in my install to create a table: $installer->run( "CREATE TABLE IF NOT EXISTS `npcallnations_orders` ( `id` INT AUTO_INCREMENT, `order` int, `...
Stordon's user avatar
  • 166
1 vote
1 answer
2k views

Magento 1.9.x - i want to add some text to order number?

I want to add some prefix to order number. Our website has 6 stores and i wanna classify which store customer purchase the item. You know, orders in ebay and amazon already have their own prefix to ...
3CE's user avatar
  • 594
0 votes
1 answer
177 views

Order / Invoice - Prefix "16-" NOT POSSIBLE?

I need to customize my prefix for the order / invoice ID´s. So my order number should look like this: 16-0001 I need the year as prefix with an "-". But when I try this: UPDATE eav_entity_store SET ...
Bernd's user avatar
  • 41
0 votes
2 answers
2k views

I need table name with prefix in custom controller file. [magento 2]

public function checkHelpful($rid ,$pid ,$uid ) { $connection = $this->objectManager->get('Magento\Framework\App\ResourceConnection'); $tbl = $connection->getTableName('catalog/...
Ashish Jagnani's user avatar
4 votes
3 answers
7k views

Magento 2.0 Programmatically get the prefix used for Tables

I am doing some raw sql opertaions and would like to know if there is a way to get programmatically the Prefix used for the tables (the prefix you set during the Magento installation)?
Rahahaha's user avatar
  • 429
0 votes
1 answer
76 views

Order Prefix wont work

I changed in the table "eav_entity_text" my order "increment prefix" into "ON-" and in "increment_last_id" i set it to "ON-10001". Also i changed in table "eav_entity_type" the "increment_pad_length" ...
Stefan Grauer's user avatar
3 votes
3 answers
2k views

"Prefix is a required field" on logged in checkout

I have a magento with a default onepage checkout. When a fresh registered, active customer tries to checkout I get the message "Prefix is a required field" no matter if the customer has already ...
Bernhard Prange's user avatar
1 vote
2 answers
1k views

How to add prefix in order code in magento by payment methods

I need to add prefix in order number in magento. Like If Order is Cash On Delivery Based then order no should to be like... cod12332434343.... if order is prepaid..then it should be pre12323233223 .......
Deepak Rai's user avatar
  • 1,145
2 votes
2 answers
2k views

How add table name prefix to all table after Magento installation

I need to add table prefix for all the database table. I know that I can get this option while installing the Magento but I already installed my magento and I don't want to change the database, I ...
Charlie's user avatar
  • 3,136