نحوه استخراج شماره های موبایل

[saman_e_rsa]

با سلام چطوری میتونم شماره موبایل تمامی مشتریها رو یکجا داونلود کنم آیا همچین امکانی وجود داره

 

ممنون میشم راهنمایی فرمائید

 

ارادتمند شما

[admin]

دانوش جان توضیح دادن قبلا. باید با دستورات sql آشنا باشید بعد میتونید از خود مدیریت پرستا خروجی بگیرید

[saman_e_rsa]

متاسفانه ندیدم و خیلی هم با sql آشنای ندارم مگر اینکه برای همین مورد خاص آموزش وجود داشته باشه عالی میشه

[general2]

https://ipresta.ir/blog/108_export-emails-phone-number-csv.html

 

من طبق این آموزش پیش رفتم ولی خروجی که به من میده این هست :

"شناسه";"نام درخواست SQL";"SQL query";
"6";"Number 2";" ps_customer ps_customer_group ps_customer_message ps_customer_message_sync_imap ps_customer_thread ps_customization ps_customization_field_lang ps_customized_data ps_export_customer_fields";
"7";"مشتریان > مدیریت مشتریان";"SELECT<br />								a.`id_customer`, `firstname`, `lastname`, `email`, a.`active` AS `active`, `newsletter`, `optin`<br />			, <br />        a.date_add, gl.name as title, (<br />            SELECT SUM(total_paid_real / conversion_rate)<br />            FROM ps_orders o<br />            WHERE o.id_customer = a.id_customer<br />             AND o.id_shop IN (1) <br />            AND o.valid = 1<br />        ) as total_spent, (<br />            SELECT c.date_add FROM ps_guest g<br />            LEFT JOIN ps_connections c ON c.id_guest = g.id_guest<br />            WHERE g.id_customer = a.id_customer<br />            ORDER BY c.date_add DESC<br />            LIMIT 1<br />        ) as connect<br />			FROM `ps_customer` a <br />			<br />			LEFT JOIN ps_gender_lang gl ON (a.id_gender = gl.id_gender AND gl.id_lang = 1) <br />			 WHERE 1  AND a.`deleted` = 0 <br />			<br />			 ORDER BY `date_add` DESC";
"8";"مشتریان > آدرس‌ها";"SELECT<br />								a.`id_address`, a.`firstname` AS `firstname`, a.`lastname` AS `lastname`, `address1`, `postcode`, `city`, cl.`id_country` AS `country`<br />			, cl.`name` as country<br />			FROM `ps_address` a <br />			<br />			<br />			LEFT JOIN `ps_country_lang` cl ON (cl.`id_country` = a.`id_country` AND cl.`id_lang` = 1)<br />			LEFT JOIN `ps_customer` c ON a.id_customer = c.id_customer<br />		 <br />			 WHERE 1  AND a.id_customer != 0  AND c.id_shop IN (1)  AND a.`deleted` = 0 <br />			<br />			 ORDER BY a.`id_address` ASC";
"9";"export emails";"select c.firstname,c.lastname,c.email,a.phone_mobile<br /><br />from ps_customer c<br /><br />left join ps_address a on (a.id_customer = c.id_customer)<br /><br />where c.active<br /><br />AND a.phone_mobile != ''<br /><br />GROUP BY a.phone_mobile<br /><br />ORDER BY a.phone_mobile desc";

حدود ششضد مشتری داریم ولی شماره ای درش نیست!

[ramtin2025]

https://ipresta.ir/blog/108_export-emails-phone-number-csv.html

 

من طبق این آموزش پیش رفتم ولی خروجی که به من میده این هست :

"شناسه";"نام درخواست SQL";"SQL query";
"6";"Number 2";" ps_customer ps_customer_group ps_customer_message ps_customer_message_sync_imap ps_customer_thread ps_customization ps_customization_field_lang ps_customized_data ps_export_customer_fields";
"7";"مشتریان > مدیریت مشتریان";"SELECT<br />								a.`id_customer`, `firstname`, `lastname`, `email`, a.`active` AS `active`, `newsletter`, `optin`<br />			, <br />        a.date_add, gl.name as title, (<br />            SELECT SUM(total_paid_real / conversion_rate)<br />            FROM ps_orders o<br />            WHERE o.id_customer = a.id_customer<br />             AND o.id_shop IN (1) <br />            AND o.valid = 1<br />        ) as total_spent, (<br />            SELECT c.date_add FROM ps_guest g<br />            LEFT JOIN ps_connections c ON c.id_guest = g.id_guest<br />            WHERE g.id_customer = a.id_customer<br />            ORDER BY c.date_add DESC<br />            LIMIT 1<br />        ) as connect<br />			FROM `ps_customer` a <br />			<br />			LEFT JOIN ps_gender_lang gl ON (a.id_gender = gl.id_gender AND gl.id_lang = 1) <br />			 WHERE 1  AND a.`deleted` = 0 <br />			<br />			 ORDER BY `date_add` DESC";
"8";"مشتریان > آدرس‌ها";"SELECT<br />								a.`id_address`, a.`firstname` AS `firstname`, a.`lastname` AS `lastname`, `address1`, `postcode`, `city`, cl.`id_country` AS `country`<br />			, cl.`name` as country<br />			FROM `ps_address` a <br />			<br />			<br />			LEFT JOIN `ps_country_lang` cl ON (cl.`id_country` = a.`id_country` AND cl.`id_lang` = 1)<br />			LEFT JOIN `ps_customer` c ON a.id_customer = c.id_customer<br />		 <br />			 WHERE 1  AND a.id_customer != 0  AND c.id_shop IN (1)  AND a.`deleted` = 0 <br />			<br />			 ORDER BY a.`id_address` ASC";
"9";"export emails";"select c.firstname,c.lastname,c.email,a.phone_mobile<br /><br />from ps_customer c<br /><br />left join ps_address a on (a.id_customer = c.id_customer)<br /><br />where c.active<br /><br />AND a.phone_mobile != ''<br /><br />GROUP BY a.phone_mobile<br /><br />ORDER BY a.phone_mobile desc";

حدود ششضد مشتری داریم ولی شماره ای درش نیست!

احتمالا بخش ثبت نام و خرید شما تغییر پیدا کرده یا از ماژول خاصی استفاده میکنید که شماره ها مطابق حالت پیشفرض ذخیره نمیشه. اگه اینطور نیست میتونید تیکت بزنید تا بررسی بشه