Questions tagged [csv]

Denotes questions related to CSV file management on Magento (import,export,creation,modification)

Filter by
Sorted by
Tagged with
0
votes
0answers
17 views

Connecting SFTP in Magento 2

I am still a newbie in Magento. I am looking for a way to read csv file for automating product upload to Magento. I will be receiving the csv file that contains the product attributes (data and images)...
2
votes
0answers
17 views

Magento2 import stock sources successful but no changes made and not showing in import history

Preconditions (*) Magento ver. 2.3.4 About 10000 skus, this process has worked many times previously, suddenly stops working. No new modules or configurations have been done since last time the ...
0
votes
1answer
12 views

How to have a CSV with customer, order and shipping information since a date?

I'm running a Magento Commerce Cloud B2B, and I need to get a CSV list of these data below, the most important data to me is the client's phone number which is inside the shipping information since a ...
0
votes
3answers
43 views

MAGENTO 2.4 EXPORT CSV FILE STUCK IN QUEU AND NEVER APPEARS TO DOWNLOAD IT

HELP..!! I am on Magento 2.4 trying to export products but EXPORT FILE STUCK IN QUEUE.... it never appears.. what can i do? Thanks in advance!
0
votes
3answers
31 views

Magento 2 how to read the uploaded csv from front end form

Here am trying to read the csv file which is uploaded by frontend form. but am not able to open or read the file content. here is form file code. <form class="import-shipping-form" action=...
-1
votes
0answers
27 views

How to add customer group in the newsletter subscribers CSV exported?

I'm using Magento 2.3.5-p1 and I would like to add a new column in the exported newsletter subscribers CSV, this column must contain the customer group. I tried it in the newsletter_subscriber_block....
0
votes
0answers
15 views

How to create import csv option in admin configuration of Magento 2.3

I want to create a configuration for may custom module where i need to add import csv field. Once i upload my csv it should upload all the data to my custom table. Below is the code I have added to ...
0
votes
0answers
5 views

Magento2 : How can i use use_default[url_key] option to be chcked using CSV upload

Using product CSV upload I want to to be checked the use default option for url_key as i have multiple stores. I have tried use_dafult_url_key option in CSV but its not working
0
votes
0answers
15 views

Magento 2.4: upload bulk product images failing due to dashes in filename?

It seems I'm having an issue with importing product images using csv. Just so you know, all images are in /var/import/images/. In the csv no path is written, just filenames (Using Magento 2.4). The ...
0
votes
0answers
12 views

magento 1.9, export data from grid to csv file

I am trying to export data to from my module to CSV file in my grid.php file i have this code in _prepareColumns() $this->addExportType('*/*/groupDataExportToCsv', Mage::helper('...
0
votes
0answers
30 views

Magento 2.4 Import grouped product with custom relation

I'm using this module https://github.com/50x/Boolfly_ProductRelation to create custom additional relation in grouped products. It works well except for the import functionality. I've tested import ...
0
votes
0answers
24 views

How to get controller path for $postUrl for reading CSV in Magento 2?

I have created custom button in Admin Menu for import CSV and created a controller with below path app/code/Tym17/AdminSample/Controller/Adminhtml/SampleTwo/Index.php Used this in my phtml file with ...
0
votes
1answer
31 views

How to create a simple products programmatically using CSV data in Magento 2 admin?

I have created a file uploader on my backend admin. I want to update my products using programmatically by using an csv uploaded. My controller file is <?php namespace Tym17\AdminSample\Controller\...
0
votes
0answers
9 views

Downloadable products csv - unable to set links_purchased_separately = 0

I have a csv for downloadable products. I need to set links can be purchased separately to 0/false. In my csv file, field downloadable_links is set as url=https://www.feedbooks.com/book/81.epub,...
3
votes
1answer
46 views

Creating a csv file that contains product details magento 1

I am trying to create a csv, using script that contains the below product attributes. (id, title, description, link, image_link, price, availability) in Magento 1 Has anyone implemented it? Or Any ...
0
votes
0answers
10 views

Display double quote in order id field in order CSV export Magento 2.3.4

I had generated the Order CSV by own in Sales Order page iam getting the ("Extra Order Id") double quotes in csv for first column. <?php namespace Sm\FileGeneration\Controller\Index; use ...
0
votes
0answers
13 views

Magento 2: Can't translate New Shipping Address Popup Form label in checkout page

I'm using Magento 2.3.4 and i tried to translate the City input label inside the new address popup form in checkout page (when we already have an address). I tried using the en_US.csv inside the theme,...
1
vote
0answers
15 views

Import add and update products with their attributes in a CSV file and cron job Magento2

I am using Magento 2.3.3 and wants to import products using cron and csv. I have google Sheet which contains all products data and sheet's data changes continuously. So I have to run a cron every day ...
2
votes
3answers
160 views

Import new and update products and their attributes with a CSV file and cron job Magento2

I am using Magento 2.3.3 and wants to import products using cron and csv. I have google Sheet which contains all products data and sheet's data changes continuously. So I have to run a cron every day ...
1
vote
2answers
42 views

Magento 2 : How to create a ConverToCsv.php for company admin grid export?

I want to create a custom export csv file for company grid.I got to know that we can create ConvertToCsv.php to do that. Can someone explain steps on how to do that?
1
vote
1answer
32 views

Error while importing products through csv in magento 2

I am trying to update my product price through csv. When I run this import, I am getting this error: -> The value specified in the URL Key field would generate a URL that already exists. https://...
0
votes
1answer
35 views

magento 2 How to add new column in order csv export

magento 2 How to add new column qty ordered in order csv export. and coumn should not be visible in the grid
0
votes
1answer
29 views

Fastest Way to Update Product Custom Attributes and Product Name, Product Weight using csv in magento1.9

We want update existing created products Product Name, Product Weight and custom attributes using csv file. We have csv file and want compare existing created Product SKU in website with Product SKU ...
0
votes
0answers
10 views

Csv file empty after export orderd products list

I have found a list of ordered products in Magento 2 admin -> reports -> products -> ordered. that's working properly. but after that, I export that list as a CSV file. but after downloaded it's ...
0
votes
0answers
25 views

How to Bulk Import product video using csv import sheet Magento 2

I'm trying to import product video using csv import. Is there a way to import product videos..?? How can i achieve this using import..?? Thanks in Advance.
0
votes
1answer
21 views

Magento 2 can't remove post params when reload

I'm trying to import stock using csv. When I click on submit, the import functionality works fine. But when i click on reload when it is posting then it loads until the post function completes. <?...
0
votes
0answers
20 views

Magento 2, export data from magento 2 into a csv file using PHP

I need to export data from magento 2 into a csv file. Data needs to be like this: You see, i want to know what customer ordered what and how much. [Customer];<Id>=10447;<KDemail>=kerstin....
0
votes
1answer
12 views

How to export multistore product data from DB?

My client wants to have a CSV file containing three columns, the product SKU, website ID (1 = CA, 2 = US) and the final price. How could I do it?
0
votes
0answers
35 views

Get product data from Magento2 and push it to googlesheets

Tell me a way how to automatically upload data to google sheets from a CSV file that Magento 2 will create by cron. I have implemented functionality for exporting data from Magento 2 about products, ...
0
votes
0answers
30 views

Magento 2 Delete download file from downloadable product via csv

I want to update my downloadable product via csv by removing current assign downloadable file and assign new file to the product as shown in screenshot I want to delete this test_image2.zip file and ...
0
votes
0answers
25 views

Magento 2 csv product import change separator

I am trying to import a product csv to magento 2 instance using command line . I have followed this link https://www.thirdandgrove.com/insights/importing-products-magento2-part2/ This code is ...
0
votes
0answers
29 views

Import Address from CSV with multiple 'street' elements

I have some source customer/address data from an old system which needs to be imported to Magento from a CSV file. The source data has multiple Address elements (house name, address 1, address 2, ...
0
votes
0answers
64 views

Magento2 migrate wishlist data programatically from M1

Magento 2 we would like to migrate wishlist data from M1 Unable to add (or) insert code & value (params) columns data to wishlist_item_option table programatically. Can anyone review my code ...
0
votes
1answer
14 views

CSV Upload errors, even after adding all attribute values

I'm trying to add custom attributes using a CSV. I'm using the header additional_attributes. I have attributes called "main category" and "sub_category", and they're in the additional_attributes ...
0
votes
0answers
15 views

Get Orders CSV with ordered product name and customer's city

i want to get orders data that i export from order>>sales after pressing Export button but i want in this csv with product name and customer's city. I will be very thank full.
0
votes
0answers
11 views

How can i upload CSV in Webkul B2B with custom attribute

Hey There i am using WebKul's B2B,Mass Upload and Custom Attribute and it allows seller to upload products using csv and also allows admin to add new field or attribute but i dont have have any idea ...
0
votes
0answers
21 views

In magento 2 How to import image from ftp server having restricted access

The ftp can be accessed only through credentials can Iget images from that ftp for magento. Is that Possible?
0
votes
0answers
18 views

Admin csv uploader

I have created a empty admin page, it appears in the side bar and redirect to the correct place although I don't have a controller working. In this page I need a csv uploader then I need to send and ...
0
votes
0answers
19 views

Magento 2.3: CRON job is not working in custom module

I have created a module for collecting customer data from the Magento database and sending them as a CSV file to another server by hitting the controller URL in browser. Now, I want it to be send ...
0
votes
0answers
23 views

Recursively Replace certain characters on server (Cent0s) to import images in Magento 2

I have a folder for all my product images which are structured to mimic the categories. Now some of these folders, and some product images have some special characters in them. Mostly & and Ë, Now ...
1
vote
1answer
220 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"); ...
0
votes
2answers
56 views

Bulk Export Magneto 2 product PSV

I'm using Magneto 2.3.3 on Ubuntu 18.04. I'm having 141 000 products that I want to export to a CSV file. Nothing happens when I try to export. It just says Message is added to queue, wait to ...
0
votes
0answers
33 views

Magento 1.9 - How to update table values using CSV?

I want to add alt tags to my all 50K products so that i plan to update table catalog_product_entity_media_gallery_value. After created csv and directly imported to the table ...
0
votes
4answers
48 views

Magento CE 2.3.1 Product Import issue

I am facing issue import Magento stock source importing. please check the snapshot Upload CSV: https://prnt.sc/ranqvc and getting error snapshot: https://prnt.sc/ranr13 Below my CSV ...
0
votes
0answers
10 views

Magento2 Import csv without required attribute like attribute_set_code and product_type

Magento2 Import CVS without required attribute like attribute_set_code and product_type Note: we can add run time while CVS running
0
votes
0answers
26 views

Magento 2: Product Import through csv without SKU

can we import products through csv without sku column? how to add with same unique attribute same as sku ? note: don't suggest add random value for sku.
1
vote
1answer
17 views

Magento 1.9 - After Export Products, Category few columns values like 000,000,000

After export products, category few columns like 12,223,234,544,348,000,000,000 what is mean 000. How to view what category it is? FYI - few products assigned to more than one category like 6 or 7 ...
0
votes
0answers
15 views

Magento2 - CSV Export problem

Using cron job in Magento my database is exported (.csv). In my server every 5 minutes but in this way server becomes full quickly. Is it possible to override previous .csv in server and not create a ...
0
votes
1answer
20 views

Add custom group_id to customers on upload

I'm trying to add 5000 customers using the csv uploader. I used the API to add all 5000 customer codes, but when I try to use the csv uploader, it says: Value for group_id attribute contains ...
0
votes
0answers
30 views

Uploading customers with multiple email addresses and multiple addresses (csv)

I'm trying to upload 5000 customers to a client's site. His data is all CSV, and I'd like to use the CSV uploader. Is there a way to upload a customer with multiple email addresses? Also, is there ...

1
2 3 4 5
12