Questions tagged [table]

This tag is ambiguous. For database tables, use "database", for html tables use "template" or "html", for shipping table rates use "table-rates"

Filter by
Sorted by
Tagged with
1 vote
2 answers
46 views

Insert data into custom table in magento 2

I have created a custom table in database of magento 2. I want to insert some data into this custom table. I want to pass this data from controller to the custom table in magento 2.4. Please can any ...
user avatar
1 vote
0 answers
42 views

Magento 2 Mailchimp Abadoned cart email not working

In the current Using version we are using Magento 2.4. We are Using this Mailchimp Magento extension - https://marketplace.magento.com/mailchimp-mc-magento2.html We upgraded the Magento version from 2....
user avatar
  • 1,123
0 votes
1 answer
44 views

How to add table schema as a dependency in setup patch data?

I am creating a custom Module, in that I created a custom table and patch data. The patch data for inserting data into that table. Now the issue is, the custom table was created through declarative ...
user avatar
0 votes
1 answer
559 views

Magento 2 How to create graphql mutation

How to create custom graphql mutation in custom module in magento 2. And how to save custom form data in custom table using mutation. THANKS.
user avatar
  • 3,157
0 votes
3 answers
50 views

Magneto2: Base table or view not found table amasty_conf_group_attr doesn't exist

The changes made in products attributes doesn't show on the frontend. The part of the database won't update and shows the following message. "Base table or view not found table ...
user avatar
  • 3
0 votes
1 answer
44 views

Which tables need to restore to get backup of all customers in magento 2.4.1

I am using magneto 2.4.1. Accidently I have deleted all my customer lists but I have a backup. So now which tables I need to restore to get back those all customer list.
user avatar
0 votes
1 answer
43 views

Magento 2: Get all bundle products

So I have to create a report (SQL Script) which has all the bundle products and all its customizable options. I can get list of all the bundle products using this query. select entity_id, type_id, sku,...
user avatar
0 votes
0 answers
254 views

How to edit a table built with localstorage

I have built an application that takes user input and adds the values to a table on submit. I wanted to integrate an undo button that removes the most recent item that was added from the table. Here ...
user avatar
  • 1
0 votes
2 answers
30 views

Increase the width of the product table in the order confirmation template

I'm trying to help my friend out who has a Magento Store, (2.3.6). I'm a little new to Magento but am experienced with PHP, HTML, CSS. Order confirmation emails are coming through badly formatted and ...
user avatar
  • 1
0 votes
0 answers
21 views

Magento 2 | Join a table to getLoadedProductCollection()

I'm trying to join the tier price table to the getLoadedProductCollection () collection located in the list.phtml file. What I would like to do is filter the products in the current category by tier ...
user avatar
  • 285
0 votes
1 answer
41 views

I have confusion take of sales_sequence_profile table in Magento 2

Can anyone explain where what's the use of this table or where it will work? Thanks
user avatar
0 votes
0 answers
27 views

Magento 2.4: How to add a new table in Magento DB to retrieve one of its fields to calculate brokerage that gets added to the shipping to Canada?

FedEx module's Carrier.php is extended in custom shipping module of our Magento store to get shipping rates for Canadian addresses. I used FedEx results object to set the carrier to custom shipping as ...
user avatar
0 votes
1 answer
164 views

How to set 2 auto increment id in table[Magento 2]

is there any way to create 2 auto increment id in same table?When im trying to create using db_schema, error showing that only primary key id can get this auto increment.is there any other ways?
user avatar
  • 5
0 votes
3 answers
2k views

Magento 2: How to get last inserted custom table Id without saving new item?

I want to get the last inserted id to my block without adding new data into the table. I want to use this value to automatically filled in my phtml file. I tried getId and it's not working. I just ...
user avatar
  • 5
-1 votes
2 answers
49 views

I need to display table data in my custom module at the front end of the site. Its saying wrong argument for $collection

/*Showdata.php Controller\Index */ <?php namespace Eaglerocket\Customquote\Controller\Index; use Magento\Framework\App\Action\Context; use Magento\Framework\View\Result\PageFactory; use Magento\...
user avatar
  • 19
0 votes
1 answer
295 views

How to get data from table in block magento2? Note: my model is in another module and i want to get data in another module.[frontend]

I have databse table with data.My model was created in one module and i want to get table data in another module's block class, so that i can render those data into my phtml. table name:form columns:...
user avatar
  • 5
0 votes
1 answer
308 views

Add row number in admin custom table Magento 2

I've made a new module. Here, I've override the AbstractFieldArray class. <?php namespace myVendor\myModule\Block\System\Form\Field; use Magento\Config\Block\System\Config\Form\Field\...
user avatar
0 votes
1 answer
67 views

Trying to remove unwanted space in a table,

I'm trying to create a 6 cell table on my site that contains 3 images and i want the corners of the three images to touch, with no boarder or padding. I've tried everything I can think of but ...
user avatar
1 vote
3 answers
573 views

How to check installed extensions on database magento 2

I need to check installed module on database table I hope your help Thanks Thomas
user avatar
0 votes
4 answers
2k views

Magento 2 - Check if record with certain value already exist in table before creating it

I created a new table company_shipping_quote. I am writing data into it like this: $quoteId = $quote->getId(); $html = $this->_generateNote($expressRule); $quoteModel = $this->...
user avatar
  • 2,402
0 votes
1 answer
901 views

In which table in database Magento 2 product will insert with image and custom attribute?

What are the basic tables which need to use, so Product data will be inserted with image and custom attribute. Which is visible both in frontend and admin. Please Any one point out the table name for ...
user avatar
  • 526
0 votes
1 answer
16 views

No show customers in Customers section table

I have a problem after upgrade from 2.3 to 2.4. After correctly upgrate I don't see customers inside the table customers. In particular, I'm seeing only the first row on the table while all other rows ...
user avatar
0 votes
0 answers
21 views

Magento2 fetch value from catalog_compare_item table

Magento2 How can I get the value of following table 'catalog_compare_item' using a model or any other proper way of Magento?
user avatar
  • 3,426
0 votes
1 answer
60 views

Change database in Resource model

I split my database on 3 parts. In my env php is set default, but in one of my model i need to connect to table wich located in different db. How can i change target db?
user avatar
0 votes
1 answer
34 views

Base DB schema didn't create table

In my report_sales > coupons page I get exception Base table or view not found: 1146 Table salesrule_coupon_aggregated doesn't exist And I find out that system didn't create this table (It doesn't ...
user avatar
0 votes
1 answer
27 views

I created a custom Module, but table is not created, i also checked in core_resource, it's not there

Here is the code config.xml <?xml version="1.0"?> <config> <modules> <Bms_Calls> <version>0.1.0</version> </...
user avatar
0 votes
2 answers
463 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-...
user avatar
  • 139
2 votes
1 answer
180 views

Can not save in db custom json value on block

In my plugin I created a new table 'myapp_staging' made of three columns: 'id', 'id_api_call' and 'f24_options_value'. In the last field I would like to save a response to my Api call in json format. ...
user avatar
0 votes
1 answer
82 views

How to create table in widget.xml

I wanna add a html table in widget.xml. I mean this: instead of this: Is this possible? Thanks.
user avatar
  • 1,168
0 votes
1 answer
359 views

Megnto 2 - table 'magento.store_website' doesn't exist

I am a newbie to Magento. My friend requested me to make some changes to his existing Magento 2 website and gave a Full CPanel backup. When I executed the Database dump, I noticed that only a few ...
user avatar
  • 1
0 votes
0 answers
37 views

Magento2 store table the store_id needs changed from 2 to 0 to be reset

Not sure how it has occurred, but in our store table, the store_id has changed to 2, but should be 0 I believe for admin. What is the query to run to reset it? We have backups with the correct values,...
user avatar
  • 1,013
0 votes
1 answer
35 views

Help to create grid for a table

I need to create a simple adminhtml grid to a table. I went through several tutorials on the internet and none worked. It's a simple table with an ID, text1, text2, created_at and updated_at columns. ...
user avatar
0 votes
1 answer
28 views

jquery in how to get the children without tag id using?

j query in how to get the children without tag id using ? i have using table structure to get the children but last children not getting. I have try this Code $(document).ajaxComplete(function (...
user avatar
1 vote
1 answer
536 views

Magento 1.9 - How to write script for bulk update values in table using csv?

Try to bulk update label name in catalog_product_entity_media_gallery_value, CSV formate : Workout: <?php require_once 'app/Mage.php'; umask("0"); Mage::app(); ini_set('display_errors',"1"); ...
user avatar
  • 103
1 vote
2 answers
218 views

Magento 2.3 InstallSchema.php does not create any table

I have an InstallSchema.php that does not create the table in the database. Here is the code of the schema php: <?php namespace MyVendor\News\Setup; use Magento\Framework\Setup\...
user avatar
0 votes
1 answer
1k views

Missing setup_module table in Magento 2.3.2 database

i am missing a table setup_module in magent 2.3.2 database, the site is working, however i cannot install any extensions as the new tables are not being created due to missing setup_module. i could ...
user avatar
1 vote
2 answers
513 views

Magento 2: New field in checkout page, find its input value store in which table of database

I created a new field example in the checkout shipping. label example I can check in the table eav_attribte like the below images. But in which table I can check it's Input value if I put a value ...
user avatar
  • 161
0 votes
1 answer
60 views

difference tables 'quote' and 'quote_adress"

What is the 'quote' table for? And what is the difference between 'quote' and 'quote_adress' table ? Does anyone know what is the difference ? Thanks in advance.
user avatar
  • 139
3 votes
1 answer
694 views

How to rename an existing custom table in Magento 2?

I created a table with name "Redeem_blanace" using InstallSchema.php as: class InstallSchema implements InstallSchemaInterface { /** * {@inheritdoc} * @SuppressWarnings(PHPMD....
user avatar
  • 1,521
1 vote
4 answers
370 views

Magento 2 data migration triggers table missing in M1

We have successfully migrated data from M1 to M2 using the data migration tool. We have a custom table called md_cybersource which is mapped to magedelight_cybersource in map.xml When we run delta ...
user avatar
0 votes
2 answers
402 views

product view count table in database magento 2?

I have to write code for getting product count.it is working fine but i want to know where the count record comes? public function getProductCount($id) { $prodData = $this->_prodCollection-&...
user avatar
  • 422
1 vote
1 answer
439 views

Magento 2 EE | How to create/update new record in magento_customerbalance_history table?

I am trying it as: Using the collection \Magento\CustomerBalance\Model\Balance\HistoryFactory $historyFactory As $model = $this->_historyFactory->create(); //$model->setId(2); $...
user avatar
  • 1,521
0 votes
0 answers
29 views

How to display numbers of row in table to section in configuration system

I want to count the rows of table and display it to field in section system, can someone help me how to resolve this. Thanks!
user avatar
0 votes
1 answer
2k views

Magento 2 display certain rows from custom table in admin grid

I have a custom table(id,product_id,company_code) that is displayed on the backend as a grid. To create the grid, I followed this link. This displays all the records from the table. I need to show ...
user avatar
  • 467
3 votes
1 answer
131 views

Magento 2. Declarative schema. What is the use of the memory engine?

When creating tables using the Declarative Schema one can set the engine="" attribute value as memory. I can't seem to find an example in the core. What is a use-case for this configuration, how does ...
user avatar
0 votes
1 answer
45 views

Table where global names is stored

I have an issue in Magento where few of my tables and reports are showing the product names/Category in French language.We do have a store at France and in other countries, but the requirement is to ...
user avatar
  • 115
2 votes
2 answers
978 views

How to create a table in configuration system.xml file in Magento 2?

How can i create table in system.xml file is there any way? I had searched around but can't find any solution want to create like this
user avatar
  • 1,321
0 votes
0 answers
357 views

Magento 2 : Create and Handle Many to Many Relationship Between Two Table

I have two custom table that is related by many to many relationships. So how to create these two tables: is there a specific syntax? and how to handle this type of relation thanks in advance
user avatar
2 votes
1 answer
395 views

Suddenly customer_grid_flat table delete in magento 2

I am using Magento 2.2.6. My site is working fine. But today morning I show customer_grid_flat table delete in my database. Please, someone, let me know why it's doing. Also in Admin side customer ...
user avatar
3 votes
0 answers
241 views

What is the difference Between cataloginventory_stock_status & cataloginventory_stock_status_idx

If I use cataloginventory_stock_status and cataloginventory_stock_status_idx return different values, what is the main difference between these two tables?
user avatar
  • 103